1 Reply Latest reply on Sep 28, 2018 2:27 AM by Chetan Bothra

    Calculating MAU on each date of past 30 days.

    Chetan Bothra

      Hi I am very newbie to tableau and I am just not figuring out how to calculate MAU for each date based on past 30 days.

       

      Lets say my dates are like 17,18,19,20,21 and so on. What I would like is to calculate MAU on date 17 based on past 30 days from 17. Same for rest of the dates for eg on 18 I would like to calculate MAU on 18 based on past 30 days.

       

      On a side note I already have the calculations done for DAU which is correct and I cross checked the DAU with the raw sql query.

       

      Can anyone help me to achieve this?

       

      Thanks-in-advance.