Accumulative rolling calculations over unselected period

max31 — Mon, 30 Sep 2019 08:39:09 GMT

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!

Re: Accumulative rolling calculations over unselected period

max31 — Mon, 04 Nov 2019 09:44:37 GMT

Actually the problem came from my data sorting. Once I updated the sorting it was fine.
If you have the same issue take a look to this solution.