4 Replies Latest reply on Mar 3, 2016 6:46 AM by Suresh Sridharan

    Pie chart

    Suresh Sridharan

      Hi,

      I would like to have a pie chart for the below table

       

      Project ID
      Period
      Milestone AMilestone BMilestone C
      10001Jan 2016XX
      10002Jan 2016XX
      10003Jan 2016X
      10004Jan 2016XXX
      10005Feb 2016
      10006Feb 2016X
      10007March 2016XX
      10008March 2016XX
      10009March 2016X

       

      I would like to have period-wise pie chart. The calculation is like this:

      in Period Jan 2016 - there are 8 Xs in total. So the pie for Milestone A is 3/8, for B it is 2/8 and for C, it is 3/8.

      in Period Feb 2016 - there is only 1 X. So the pie is (=1/1) 100% for Milestone A

      Similarly in Mar 2016 - there are 5 Xs. So the pie for Milestone A is 2/5, for B it is 2/5 and for C, it is 1/5.

       

       

      Can someone please help me on this.

       

      Thanks,

      Suresh