1 Reply Latest reply on Jun 16, 2017 7:52 AM by xxx202xxx

    How to Pie Chart the following scenario?

    xxx202xxx

      I have a ServiceMGMT table where each Ticket has a  field called Status with 6 types, Pending, WorkInProgress, Re-Assigned, Closed, Cancelled and Resolved.  I am trying to figure out how to write an ExecuteSQL for Charting purposes where the following happens.

       

      I want to label the all the Pending, WorkInProgress and Re-Assigned Status Tickets AS "Opened" and all of the Closed and Resolved tickets AS "Closed" for each quarter of the year.

       

      I also want to count these two Groups (Opened and Closed) as the slices for each quarter of the year.

       

      Need help with the code.  Please help.