7 day rolling avg

[Anonymous]

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.

[Chanty4u]

Hi

see this

Calculating rolling n-period totals, averages or other aggregations

[sunny_talwar]

I would suggest you to use The As-Of Table here to remove any unnecessary complication on the front end

[Anonymous]

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

[Anonymous]

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

[sunny_talwar]

I can work for 7 days, month, quarter or an year