Forum Discussion

TrevorKent's avatar
TrevorKent
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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
Ok, so just 1 table at this time. can you describe your data in the one table.  Is there just 1 record per month or does each month have many records.  If there are many records for each month, what does each record within a month represent?