Average Time to Resolve Query Report
I would like to generate a report that shows the average time to resolve or complete tickets.
ideally i would like to have a total or ticket resolved between 0-2, 2-5,5-10 and above 10 hours. I would like to also be able to test the created time period. Can someone assist me. I have a PSQL database
example:-
Completion time # of Tickets
0-2 1952
2-5 319
5-10 160
> 10 149
Between Aug 1 and Oct 1
ideally i would like to have a total or ticket resolved between 0-2, 2-5,5-10 and above 10 hours. I would like to also be able to test the created time period. Can someone assist me. I have a PSQL database
example:-
Completion time # of Tickets
0-2 1952
2-5 319
5-10 160
> 10 149
Between Aug 1 and Oct 1