36 months rolling avg-Urgent Requirement

[bhavvibudagam]

Hi,

Can any one please help me How to calculate the 36 months Rolling Average.

what is Rolling average?Please explain.

I have used this Expression for calculating the 3years Fixed average.

=Count({<STATUSDATE_Year= {">$(=max(STATUSDATE_Year)-3)<=$(=max(STATUSDATE_Year))"},CASESTATUS={'CL''}>}MAINID)/3

based on these expression fields please help me to calculate the 36 months rolling avg.

Thanks,

[MK_QSL]

Better to do it at backend

Calculating rolling n-period totals, averages or other aggregations

[Anonymous · Accepted solution]

Hi

if your field "STATUSDATE_Year"  represents  a  year

try this in the expression in a pivot table:

if(rowno()<3,'',(Rangeavg(above(count({1} MAINID),0,3))

or

sum( aggr( rangeavg( above( count(MAINID),0,3) ),(STATUSDATE_Year))