COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: asmfloyd on 23 Jul 2025 02:26:42 PM

Title: Displaying * on bar chart
Post by: asmfloyd on 23 Jul 2025 02:26:42 PM
Hi,
  I have a bar chart and would like to display * when the measure value is <10 percentage and "GT 90" when value is >90 percentage. How can I display character values on the chart?

Thanks,
Title: Re: Displaying * on bar chart
Post by: cognostechie on 23 Jul 2025 08:02:56 PM
If this is an Aging chart then you should have different bars for different buckets. Ex: one bar for 1-30, another bar for 31-60 and so on so the last bar would accumulate data for anything that is > 90.

When you say display character values on the chart, do you mean the tooltip when you hover over the bar? Then you have to create calculated columns using a Case statement.
Title: Re: Displaying * on bar chart
Post by: asmfloyd on 23 Jul 2025 10:33:18 PM
Thank you @Cognostechie for the reply. Sorry for the confusion. I just updated the question as "percentage".
  I meant to display static percentage value on the chart for the corresponding dimension values.

But how can the chart show a character value?

Even if  we create a calculated column, how the chart can display the same?

Thanks,