COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nsaxena on 23 Jun 2015 07:34:57 AM

Title: urgennt help in pie chart creation
Post by: nsaxena on 23 Jun 2015 07:34:57 AM
Hi all ,

i have a view with column like

name,a, b, c, d .....a,b,c,d are calculated columns(percentage) in a view
each row is name uniquely identified by name...

now i want to have a pie chart for each  name having pie slices for a,b,c and d for each name.

Please advice me how to achive this

What to put in default measure,series and axis titles.

I am new to cognos :( especially charts...

Thanks
Nisha
Title: Re: urgennt help in pie chart creation
Post by: BigChris on 23 Jun 2015 08:02:07 AM
Bring in a pie chart (if you must..!) into your report and associate it with your existing query. Put your calculated percentage into the default measure and the name into the series.
Title: Re: urgennt help in pie chart creation
Post by: nsaxena on 23 Jun 2015 08:14:52 AM
hi thanks for reply..

i tried your way...but in default measure we can have only one column..

i need to show 4 percentage columns...a,b,c,d for each name

please suggest
Title: Re: urgennt help in pie chart creation
Post by: BigChris on 23 Jun 2015 08:27:10 AM
In that case you really don't want a pie chart. Try using a stacked bar or column instead.