Our team is need in of a detailed report on tickets, particularly how long one stays in a specific status.
I.e., ABC-1 Ticket Status -> Open -> In Progress -> Escalated -> In Progress -> Done.
What we need to show: How long did the ticket stay in "Escalated" before it was transitioned back to "In Progress"?
Goal: Have a report of all tickets highlighting trends, what type of tickets usually gets escalated, how long before it gets resolved, etc.