Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning all.
I have been tasked from my new client to do a 12 month rolling average in an existing Dashboard. The data is at a granular level and needs to stay at this level. I have tried the Accumulate 12 steps back but this didn't work as I do not measure by day I measure by site. Any help is much appreciated.
James
Have you tried using RangeSum(Above/Below()) functions?
tried that.
Have a look here: Calculating rolling n-period totals, averages or other aggregations.
- Marcus
Hi Marcus looks interesting I will give it a try on my test data and see.
You can also use an As-Of table. See The As-Of Table.
HIC