Tickets statistics chart calculation on different date fields and status.
Happy New Year Experts,
I need your help to design the report which should display the months in columns, open ticket, closed tickets and created tickets in that month.
Issue here is, Status field has values (New, Assigned, In Progress, Pending, Resolved, Closed, Cancelled).
There are Submit Date, Resolved Date , Closed Date field.
Count of created ticket should be based on submit date, count of open ((New, Assigned, In Progress, Pending) should be on submit date but the Closed Tickets (Resolved, Closed, Cancelled) should be based of Resolved Date and Closed Date
Note:- We have only one data source, we can't use other sources except one OOTB.
Output look like pretty much like this----> see attached image.