5 Replies Latest reply on Sep 14, 2017 10:38 AM by Angela Blackburn

    Calculation for DAU, WAU, and MAU  (Daily, Weekly and Monthly active users)

    Angela Blackburn

      Please see attached.

       

      I am trying to create 3 simple calculations in tableau based on the attached.

       

      DAU (Daily Active Users)  always be today - 1 (Yesterdays date)

      Avg DAU (This is easy)

      WAU (Weekly active users) based on the week # (See file)

      MAU (Monthly Active Users) based on total active users per month.

       

      I cannot wrap my head around the best way to do this and any help would be great.

       

      Thanks!