If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Pie Charts - Issue with color of values in the Legend

Started by mlodugu1, 18 Jan 2022 09:57:24 PM

Previous topic - Next topic

mlodugu1

Hi,

I am working with an existing report (dashboard) that has some pie charts with the same properties set except for the queries.
The slices of the pie in all charts represent the same column (data item).

For example: If there are four pie charts,  then all of them have the same 'Indicator' as the query item representing the pie slices where the indicator has values like 'Completed', 'Incomplete', 'Stuck'.
The issue is that a couple of the charts out of all have different colors for the legend values ('Completed', 'Incomplete', .......).

In other words, the colors of items in the legend is not consistent among  all the pie charts in the dashboard when it comes to the legend values/slices of pie even though the properties set are the same for all the charts. This is urgent for me so please suggest.

MFGF

Quote from: mlodugu1 on 18 Jan 2022 09:57:24 PM
Hi,

I am working with an existing report (dashboard) that has some pie charts with the same properties set except for the queries.
The slices of the pie in all charts represent the same column (data item).

For example: If there are four pie charts,  then all of them have the same 'Indicator' as the query item representing the pie slices where the indicator has values like 'Completed', 'Incomplete', 'Stuck'.
The issue is that a couple of the charts out of all have different colors for the legend values ('Completed', 'Incomplete', .......).

In other words, the colors of items in the legend is not consistent among  all the pie charts in the dashboard when it comes to the legend values/slices of pie even though the properties set are the same for all the charts. This is urgent for me so please suggest.

Hi,

Just to confirm - this is a report, not a Cognos Dashboard?

Moving ahead on the basis this is a report, if I'm understanding correctly, the issue is that the colours used in the legend (and therefore the colours of the pie slices) are not consistent for the items shown in the pies. For example, in one chart , 'Completed' might be red and 'Incomplete' might be blue, but in another chart 'Completed' might be blue and 'Incomplete' might be red?

One important question is what charts/visualizations you are using. Assuming this is Cognos 11 (as you're posting in the Cognos Analytics board), you could be using Cognos 10 AVS charts, Cognos 10 RAVE visualizations, Cognos 11.0 Java charts or Cognos 11.1 Javascript charts. Some of these provide the ability to define a conditional pallete (eg the AVS charts do). This is what you need to look at implementing.

The details for this are in the documentation - here is a link:

https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=properties-creating-conditional-color-palette-in-chart

Cheers!

MF.
Meep!