Rolling average line chart

[snehamahaveer]

Hi All,

Stuck with a new situation!! Please help.

I am trying to create a line chart which will have rolling average of targets. eg Month 1 = Targets%/1, Month 2 = Targets% (2 months total)/2, and so on.

Can some one tell me how and what will be the best way to do it.

My sample data is attached.

Dimensions are Month and Division, and expression is the rolling average.

Many thanks for your help!!

[#2]

maybe...

[#3]

dimension: Month and Division

expression1: sum(%target)/sum(Division)

expression2: sum(%target)

[snehamahaveer]

Hi Rodrigo,

Thanks for your reply.

But this is what I want to achieve.

I want a line chart where the value for Aug will be sum( months apr to aug)/num of months

[#5]

sum( %target)/count(Month)

[Frank_Hartmann]

Dimension:

month

Expressions:

Rangesum(above(aggr(sum({<Division={'1'}>}%target),Month,Division),0,RowNo()))/RowNo()

Rangesum(above(aggr(sum({<Division={'2'}>}%target),Month,Division),0,RowNo()))/RowNo()

Edit: Sortorder for month --->check LoadOrder-->original

hope this helps