Comparative Analysis

[Anonymous]

See attached.

I'm trying to compare Reasons from one Year to another as seen in the attached. I also would like to be able to compare months. How would I go about doing this?

[nagarjuna_kotha]

Like this ?

Let me know in case if u face any issue....

-Nagarjun

[nagarjuna_kotha]

u can create same for months also.........

-Nagarjun

[Anonymous]

No. What I attached is an example and prefer the formatting to be similar to what I have. I have 30 diffrent Reason codes and data starting from 2012.

[nagarjuna_kotha]

This is another type of approch...

-Nagarjun

[Anonymous]

That's better. But how would one link the YearMonth to the chart to allow counts. I was thinking something like this in my expression where I can filter on Months too.

Count({[AltState1]<Year = {2016}>}ID) Instead of adding Year change to YearMonth wildcard = 2016

Count({[AltState2]<Year = {2015}>}ID) Instead of adding Year change to YearMonth wildcard = 2015

[nagarjuna_kotha]

OKay....Like this ?

In this example year sections will not allow and rest will effect on charts as per ur selections.