Problem in creating a Pie chart

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  November 26, 2010 at 4:25 am

  #227201

  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

  from

  (

  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

  )tbl1

  )tbl2

  and the result set is :

  LC_Perc----------LY_Perc--------LN_Perc

  22%--------------18%-----------40%

  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.

  Thanks,

  Malavika.

  Please suggest something.

• ldorian81

  SSCommitted

  Points: 1694

  More actions

  February 7, 2013 at 3:05 am

  #1585292

  Hi,

  Did you manage to resolve this at all?

  Or can anyone answer this?

  Regards
  ld

  Stoke-on-Trent
  United Kingdom

  If at first you don't succeed, go to the pub and drink away your current thought plan.