Create 6 months rolling average table calculation

Looker Q&A Looker
1

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

2

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.

3

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

4

need to divide with 6 below calculation

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

Is it possible in table calculation?