Hi All, Need Help..
I want to create a 7 day rolling average but I need to use Month year on X-axis.
I am using: rangeavg(above(sum(sales),0,7))
X Axis: Month Year
Rolling average will be based on Month year, I need to calculate it based on 7 days sales.
Calculating rolling n-period totals, averages or other aggregations
The end suggestion was use Monthasof but its not possible as of now.
rangeavg(above( sum(sales),0,7) )
This is working fine if I use x-axis as days.
but the requirement is month year and There should be 4 data points for each month
I would suggest you to use The As-Of Table here to remove any unnecessary complication on the front end
Thanks Sunny for the reply.
1. The app is in Prod so I won't be able to change it.
2. Is this As of table will work for 7 day as well instead of month
I can work for 7 days, month, quarter or an year
Retrieving data ...