Rolling Average

[#1]

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

[sunny_talwar]

Have you tried using RangeSum(Above/Below()) functions?

[#3]

tried that.

[marcus_sommer]

Have a look here: Calculating rolling n-period totals, averages or other aggregations.

- Marcus

[#5]

Hi Marcus looks interesting I will give it a try on my test data and see.

[hic]

You can also use an As-Of table. See The As-Of Table.

HIC