I want to calculate moving average such that I average values for last 30 dates and not last 30 data points.
1) The data I have shows dates and values such that there are duplicate dates i.e. a given date could have multiple values. I want to calculate the average at each date such that while taking into account a 30 day period, I want these duplicate dates to be included. I do not want to aggregate my measure.
2) Also, there are nulls/blanks i.e. not all dates have a value.
Can this be done in Tableau? I am attaching a .twbx with sample data here.
Any help is greatly appreciated.
Thanks
Anu
See the attached (solution based on offline email conversations).