Create 6 months rolling average table calculation

I want to create a 6 months rolling average on count_of_students table calculation by using quarter field.
Can anyone please help me
 

17e71a06-3b08-45e9-a27c-6e148e3bb7ff.png
0 3 258
3 REPLIES 3

jcdufault
Participant II

Hello Nani,

You can do something like this: 

mean(offset_list(${field_being_averaged},0,2))

Replace the “2” with the number of rows you want to include in your average. 

Hi jcdufault,

I have tried above calculation. 
I am getting below values in the table calculation.
mean(offset_list(${student_fields.count}, 0,2))

If i use month field instead of quarter field the above calculation is working

I want Quarter in x-axis

e9c34bea-f834-41bc-aced-97f8b4394f34.png

need to divide with 6 below calculation

mean(offset_list(${student_fields.count}, 0,2))

Is it possible in table calculation?

Top Labels in this Space
Top Solution Authors