Greetings,
I need to build a query for Incident Reports that will provide a report that results in the following information:
- Escalated completion time: The amount of time between when it was assigned to its final Support Group vs its Completion Time.
- Escalation time windows: Time the ticket spent in one support group before it got moved to another support group. The name of the support groups should be included, and the technician who moved the ticket to another support group.
-The total time between ticket creation and ticket completion.
Thank you