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.
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
Quote from: nithya1224 on 04 Mar 2018 06:12:01 PM
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
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 .