Looking for a Report for Average Days open for all Queues.
I need a full report that displays the average time Open or (Avg_Days_Open) all tickets from the Queue 1, and Queue 2. We are not looking to count any tickets that are in any of the stalled states, and not include any tickets from the Category 1, and category 2 for any of the queues mentioned above. We like the layout show below. This time will be from the first time a ticket as been assigned from New to Open, and average all the tickets for each queue and display in average days.
Category Average Days
Queue 1 .585
Queue 2 1.667
I am using MySQL of course.
Any assistance would appreciated.
There are no answers at this time