Forum Discussion

Qrew Trainee

10 years ago

Easy way to do rolling 12 monthly average chart ?

I am wanting to chart the rolling 12 average of a value ie one month gets added and one gets dropped off and divided by 12. I would like actual and rolling 12 in the same chart. I can filter la...

Formulas and functions

reports and charts

_anomDiebolt_

Qrew Elite

10 years ago

I wrote a quick script to do the calculation but I think I am going to change the data as I had too many points for the chart and I just restricted the start date for now. I will come back to this later.

Moving Average
https://haversineconsulting.quickbase.com/db/bkks9wfjt

NoelleDivinagra

Qrew Trainee

7 years ago

Do you know the formula for a 12-week rolling average?

Forum Discussion

Easy way to do rolling 12 monthly average chart ?

Related Content

Average daily active employees calculation

Rolling 3 Month Average

🏆 Introducing: Certification Wins – A Monthly Celebration!

Percentages are Sums instead of Averages on the Total and Averages Rows

Help with Calculating Average Completion Time Over Several Records