0 Replies Latest reply on Jul 24, 2013 6:49 PM by ourk

    Stacked chart help in apex 4.0

    ourk

      Hi All,

      I am working on a stacked chart.below is the query

      select  null link,range label,count(total) value1,Dept value2 from
      (select '0-10' as range,count(emp_id) total,Dept from table 
      group by Dept
      union all
      select '10-20' as range,count(emp_id) total,Dept from table 
      group by Dept
      select '20-30' as range,count(emp_id) total,Dept from table 
      group by Dept
      union all
      select '30-40' as range,count(emp_id) total,Dept from table 
      group by Dept)
      

       

      i need to display the count of employee id in each department as  a stacked series. Can anyone please help me to how to get this

       

      Regards

      Ark