I want to create a 6 months rolling average on count_of_students table calculation by using quarter field.
Can anyone please help me
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
need to divide with 6 below calculation
mean(offset_list(${student_fields.count}, 0,2))
Is it possible in table calculation?