Months should come with previous months data

[prma7799]

Dear All,

1.I want current month with previous 23 months data total 24 bars should display without any selection

2.with selection

  if suppose user select any financial year like 14-15 then it will show 24 bars but here only 21 bar present

and when i select financial year 13-14 then why 2015 data come .

PFA

[thakkarrahul01]

Hi,

your expression:

Sum({<Year=, Quarter=, FinancialYear, Year={'>=$(=Max(Year)-1) <=$(=Max(Year))'}>} Values)

If you remove "Year=, Quarter=, FinancialYear," :

Sum({<Year={'>=$(=Max(Year)-1) <=$(=Max(Year))'}>} Values)

It is working fine for me.

Regards,

Rahul

[swuehl]

Change your dimension to MonthYear and make the set expression field modification on that field.

See attached.

[prma7799]

Hi Swuehl,

Thanks for Quick response.

Can you please tell me if I load data for month Oct-15 then nov-13 will come?

Thanks

[swuehl]

Well, nov-13 is already there.

If you update your data including Oct-15, then Oct-15 bar will be added and the Oct-13 bar will be removed from the bar chart, that's how a rolling 24 month display works, right?

[prma7799]

Hi Swuehl,

When I am trying to achieve Growth line the chart is not coming properly...

Please help.

PFA

[swuehl · Accepted solution]

The calculation seems correct, if you want to show a year over year change.

If you are talking about the extension of the line to the far left, you can handle that with adding the set expression to your aggregations.

[prma7799]

Thanks Dear Sir.....