Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to display 3 months rolling data in chart. How do I do please? I did scribble on the entity names for confidentiaty.
Can you please elaborate like how 3 months rolling data?
If it is measure like Sum(Sales) or Count(Orders)
then try this :-
Rangesum(Above(sum(Sales),0,3)) or Rangesum(Above(Count(Orders),0,3))
while using these two also sort of Dimension Month in ascending orders.
Or you can also use modifiers given in a measure with a normal measure like Sum(Sales) or Count(Orders)
In modifier click on none and select accumulation,
Range Custom and steps 3 for rolling 3 months and so on.
And in this case also you will need to sort dimension correctly.
Hi, Thanks for the reply.
It should be count of number of policies open and completed for different company entity types on x-axis and on y axis I need to display, region and under regions- Auto and home segregation.
I used now Rangesum(Above(Count(uwacid),0,3)) but I am not able to see modifier on th right hand side under measures. I do see data for 3 months accumulating but not showing month wise.
