AnsweredAssumed Answered

How to Pie Chart the following scenario?

Question asked by xxx202xxx on Jun 16, 2017
Latest reply on Jun 16, 2017 by 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.

Outcomes