COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cfsindorf on 19 Sep 2012 10:37:21 AM

Title: Month over Month % change
Post by: cfsindorf on 19 Sep 2012 10:37:21 AM
I need to do a chart that shows the month over month % change of a count. So on the X would be the change then y each month.  Then a bar up or down from 0.  Up red down green.

I have attached the chart I am after.


Thanks

Craig
Title: Re: Month over Month % change
Post by: RKMI on 19 Sep 2012 11:51:06 AM
Hi Craig,

Once you create the default chart with % change then in the chart properties choose condition palette and use the % change field and apply the palette. Please see attached screenshot.

Thanks,
RK
Title: Re: Month over Month % change
Post by: cfsindorf on 19 Sep 2012 11:57:31 AM
Which chart has the % change in it?
Title: Re: Month over Month % change
Post by: RKMI on 19 Sep 2012 12:04:51 PM
I'm guessing you have report studio exp. You need to bring in bar chart with the query having the % change data item and add that as your chart driver. Than apply the conditional palette on the % change data item.

Thanks,
Rk