Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
maybe...
dimension: Month and Division
expression1: sum(%target)/sum(Division)
expression2: sum(%target)
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
sum( %target)/count(Month)
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