Represent evolution index on line graph

[Pranav56]

Hi,
I am looking to put Evolution Index for a pharmaceutical company on a line graph. I am able to show in table using below formula -

( 1 + (Current Year Month data - Previous Year Month data)/Previous Year Month data)*100 / ( 1 +Total(Current Year Month data- Previous Year Month data)/ Total(Previous Year Month Data))*100

Now I have only data for 25 months only.

I need to use the above formula to put it on graph and show 12 months data. I have created a dimension MTH having 25 months data and Month Index having numbers 1 to 25.

Please provide a solution for it and provide the required formula.

[Andrea_Bertazzo · Accepted solution]

Hi @Pranav56 

I think you can use a bit of Set Analysis in your formula to keep only the latest 12 months. Something like this should work:

{$<MTH = {">=(month(now()-12)<= Month(now())"}>}

I would suggest you to have a look at what Set Analysis can do for you. There are nice guides in the community, like here.

You can also have a look at the Help page.