Rolling Month Average

[abhaysingh]

Hi All,

i want one analysis in which for every current month value it should calculate back three month average.i.e

For Apr= (Jan+Feb+Mar)/3

For Mar = (jan2015+feb2015+dec2014)/3

for Feb = (jan2015+dec2014+nov2014)/3

please help me in that..

thanks

[tresesco]

It depends on several things to approach. Where do you want this to be calculated, a textbox or chart? If chart, what would the there in the dimension? For generic, read :Calculating rolling n-period totals, averages or other aggregations

For specific help, try to create a sample qvw and share.

[abhaysingh]

hi tressco,

i have to show it as a trend for month dimension in line chart.

thanks

[tresesco]

Read the post by gwassenaar I suggested above. It explains the similar topic very nicely. Otherwise, a sample qvw could help me help you.

[jagan]

Hi,

As tresesco suggested if you attach a sample file with your expected output it would be easier to solve.

Calculating rolling n-period totals, averages or other aggregations

Regards,

Jagan.