Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I’d like to display an accumulative rolling rate over a 3 month period on a chart .
Elif & Gysbert’s posts helped a lot but I still have a question.
Let me show you my data:
Rolling A is:
rangesum( above(Count({$<month>}A),0,3) )
Rolling B is:
rangesum( above(Sum({$<month>}B),0,3) )
Result is:
( 1 - Count({$<month>}A) / Sum({$<month>}B) ) * 100
Rolling result is:
( 1 - rangesum( above(Count({$<month>}A),0,3) ) / rangesum( above(Sum({$<month>}B),0,3) ) ) * 100
Month is:
=if(Year(month)=2019 or Year(month)=2018, Date(month, 'YYYY-MM'), Null())
Would it be possible that 2017-12 and 2017-11 figures are included in “rolling A” and “rolling B” calculations even if they are not selected?
Note that the "month" filter only contains the last month value (2019-06 in my example).
Thanks a lot!