Does Cognos have this Kind of Chart

[Kiran Kandavalli]

Team,

I have a Dimension Field & Measure Field which need to be shown as in the attached file.

Dimension Field is  - Manager Name

Measure Field is - Goals

Based on the value for each Manager Bar should be highlighted in Green and Remaining Percentage should be in White.

These are the steps I followed - but no luck

1) I tried using Bullet Chart, but Bullet chart need 2 measures

2) I tried using Bar chart with and without 100% but I am not getting the white space for remaining percentage.

Please suggest me on this.

Thanks!
Kiran

[Lynn]

The chart you attached clearly shows two measures - the percentage achieved for each category (75%, 68%, 50%, etc.) all relative to the second measure which is presumably a target of 100%. Seems like a perfect case for a bullet chart.

[Kiran Kandavalli]

Hi Lynn,

Thanks for your response!

I tried using bullet chart but it is not showing as expected.

I created a Dummy Data item for Target and in the expression I mentioned as 100.

1) I am not getting the White Space
2) Sometimes Goals Percentage can be more than 100 or more. In that case the bar should show only see green color (which is not happening to me). I have set the limit as 0 to 100


Thanks!
Kiran

[Lynn]

If your figures are percentages then the actual number for 68% is 0.68 I suspect. Therefore your target is 1 (not 100).

I think it will adjust the size for values that exceed the target.