which chart to use

[cognos05]

Hi,
I have to create the below chart with each showing how percentage of quota is attained for month,quarter and year . Attached the image . I can do this in cross tab , but not sure which control to show in graphical.Its basically showing overall progress with respect to 100%.

Bascially, I can have a data item which will give the percentage to quota for month. say the result is 45% I need to have a chart with circle showing 45% complete out of 100% with color in it.

Please help with any suggestions.Attached the image for what i need to look like.

[Pratap Reddy]

I dont think you get the same visualization in Cognos.

But we can do it in Pie chart and make it as Do-nut chart whether it may be in Reports or Dashboard by changing Radius to 10-20% and you can use calculation field which get 45% in Size.

Regards,
Pratap

[Pratap Reddy]

Hi,
I have to create the below chart with each showing how percentage of quota is attained for month,quarter and year . Attached the image . I can do this in cross tab , but not sure which control to show in graphical.Its basically showing overall progress with respect to 100%.

Bascially, I can have a data item which will give the percentage to quota for month. say the result is 45% I need to have a chart with circle showing 45% complete out of 100% with color in it.

Please help with any suggestions.Attached the image for what i need to look like.

You can use three type of Guage Visualization as per your requirement which is available in Legacy Visualizations.

Size = Calculation field which is 45%
Category = Product line for camping Equipment

Regards,
Pratap

[cognos05]

HiPratap,

I used gauge chart and this is what I m getting . I need to show total 100 % and show 7 percentage is completed in green. It will be greeatly appreciated if you could help with this .

Attached what I have till now .