I would like to display a total count of tickets from the K1000 helpdesk
ideally - if the end result would show: Total count per helpdesk and how many tickets were actually closed in less than 24 hours that would be fantastic. Broken down by quarter would be "pie in the sky".
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Custom SQL report: select count(*) TOTAL from HD_TICKET T where T.CREATED > date_sub(now(), interval 24 hour) and T.TIME_CLOSED > date_sub(now(), interval 24 hour) and T.TIME_CLOSED = GREATEST(T.TIME_CLOSED, T.TIME_STALLED, T.TIME_OPENED)
Custom SQL report: select count(*) TOTAL from HD_TICKET T where T.CREATED > date_sub(now(), interval 24 hour) and T.TIME_CLOSED > date_sub(now(), interval 24 hour) and T.TIME_CLOSED = GREATEST(T.TIME_CLOSED, T.TIME_STALLED, T.TIME_OPENED)
Please log in to answer
Posted by:
nshah
11 years ago
You aren't going to be able to do that in the interface unless support has something they can do in the back end via professional services. You can create a custom SQL report that would tive you that and have it sent via email to you every day if you wanted.
I'm sure if you did a search you might find some code on helpdesk ticket counts that you could use as a template or exactly as it is.
Posted by:
mpace
11 years ago
select count(*) TOTAL from HD_TICKET T where T.CREATED > date_sub(now(), interval 24 hour) and T.TIME_CLOSED > date_sub(now(), interval 24 hour)
and T.TIME_CLOSED = GREATEST(T.TIME_CLOSED, T.TIME_STALLED, T.TIME_OPENED)
Comments:
-
Sorry, should have clarified that this report will give you a total number of tickets and tickets closed in the last 24 hours. You can change the "interval 24 hour" to tweak the time frame. - mpace 11 years ago
