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".

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)
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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. 

Answered 01/15/2013 by: nshah
Red Belt

Please log in to comment
0
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)
Answered 01/15/2013 by: mpace
Red Belt

  • 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.
Please log in to comment
Answer this question or Comment on this question for clarity