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.