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
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.