13 month chart in dimension

[rcorcoran]

Hi I have a chart in the document attached.  I want it to show the max month loaded and 12 other months data also.

Any help would be appreciated.

Rhona

now second example attached Scorecard Acute - dnd which has data for both years

[Anonymous]

Hi rhona,

so, regarding your test data, do you want to show Nov 14 (if 2014 is selected), Oct 14, Sept 14... till Nov 13?

Thanks.

[rcorcoran]

Yes Elena

I want the chart to show the Max month loaded with data and the previous 12 months as well.  showing 13 months in total.  so if the last month loaded was nov 14 then it should show till Nov 13.

Thanks

[Anonymous]

It's quite diffucult making some tests because there aren't data from Jun to Nov: can you upload complete data?

[rcorcoran]

Hi Elena

I have now attached another file with an example that has data for 2 years

Thanks

[rubenmarin · Accepted solution]

Hi Rhona, you can do this with set analysis, ie for the first expression (Dublin East...) it can be:

=Sum({$<[SA8 No waiting > 13 wks colon] ={11},HospitalGroup_SPKey={5007},ReferredYYYY, YearMonth={">=$(=AddMonths(Max(YearMonth), -12))<=$(=Max(YearMonth))"}>}ActualValue)

[rcorcoran]

Thanks Ruben that seems to work fine.

It is a great help

Rhona