Set analysis with dates

[Tatynout]

Hello guys,

i have  a line chart object with the Month as my dimension and the number of suppliers as my measure. I want to display the total number of suppliers of the last 12 months per month. The object looks like the image below. So for example , the month of January will sum up the number of suppliers from May 2018 to April 2019 and same for the other values of the Month dimension.

Can this be done with Set Analysis? Please help.

Thank you all in advance.

Tatiana 

[sunny_talwar]

January will sum up May 2018 till April 2019? Is there a logic behind doing this for January? What will Feb show? June 2018 till May 2019?

[Tatynout]

Hello Sunny_talwar,

Sorry my bad i meant to say for January we sum up the number of suppliers from February 2018 till January 2019. The logic behind this is to sum up the number of supplier for the last 12 months based on each dimension's values . 

Example:

For January we sum up February 18 till January 2019

For February we sum up from March 2018 till February 2019

For March we sum up from April 2018 till March 2019

etc...

Thank you.

Tatiana

[sunny_talwar]

May be look into implementing The As Of Table