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.