topic Re: Set Analysis - Measure sliding month from a dimension of the table in App Development

Set Analysis - Measure sliding month from a dimension of the table

supportlahaye — Thu, 15 Mar 2018 14:09:37 GMT

Hello,

I want to perform a setAnalysis that would be able to recover 3 months sliding (current month + 2 months previous) of a measurement according to the period dimensioned in the table.

Example: In the example below, here are the CAs for each calendar period:

Imagine the following data:

Period : CA : CA 3 Months Slippery

201803 : 14 280 : 96,081

201802 : 37,634 : 91,801

201801 : 44 167 : 59,167

201712 : 10,000 : etc ...

201711 : 5,000

CA measurement: sum (ca)

CA Measurement 3 Months Slippery:?

Thank you in advance for your help !

Re: Set Analysis - Measure sliding month from a dimension of the table

Digvijay_Singh — Fri, 16 Mar 2018 20:30:19 GMT

Maybe this -

Rangesum(Below(Sum(CA),0,3))

Re: Set Analysis - Measure sliding month from a dimension of the table

supportlahaye — Tue, 27 Mar 2018 14:36:55 GMT

It Works !

I use the Rangeavg in my case in the end.

Thank You so much !

Re: Set Analysis - Measure sliding month from a dimension of the table

Digvijay_Singh — Tue, 27 Mar 2018 16:26:56 GMT

Great! You may close this thread by marking correct answer.