Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Problem in creating a Pie chart Expand / Collapse
Posted Friday, November 26, 2010 4:25 AM


Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, Visits: 748
Hi All,

I have a table which stores values like Yes, Never and Close.

I need to display the % of each of them in a Pie chart.

my query is like:

select CONVERT(float,LC)/CONVERT(float,Total) as LC_Perc
,CONVERT(float,LY)/CONVERT(float,Total) as LY_Perc
,CONVERT(float,LN)/CONVERT(float,Total) as LN_Perc
select LC,LY,LN,LC+LY+LN as Total from
select sum(LessonClose) as LC,sum(LessonYes) as LY, sum(LessonNever) as LN
from Lessons


and the result set is :

I tried to plot these on the pie chart and m not getting the desired result. I get only one sector on the Pie. the other two are not mapping correctly.

Can we not display multiple columns on the same pie?

How can i solve this?

Please suggest. its bit urgent.


Please suggest something.
Post #1026731
Posted Thursday, February 7, 2013 3:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 29, 2015 3:40 AM
Points: 343, Visits: 297

Did you manage to resolve this at all?
Or can anyone answer this?


United Kingdom

If at first you don't succeed, go to the pub and drink away your current thought plan.
Post #1416916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse