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?
Does anyone have answer to this question? I am not able to figure it out yet!