I need to create a monthly report on the average time a ticket was open by owner and by location (a custom field). I can't figure out how to do this in the wizard and my SQL skills are just enought o get me by these days. It seems like there are two problems: 1) I need a timer to count the time opened for me (following the SLA Timer series on here, but it's not functional yet) in order to get the time opened. 2) i also don't know how to pull tickets from a date range. what would it be based on? created date? closed date? How do i get the closed date?

Any help would be appreciated.

Answer Summary:
1 Comment   [ - ] Hide Comment


  • I recently needed the same thing but the KB article query wasn't quite right. I've posted an updated query that accounts for weekends and holidays and allows more flexibility in the closure bands. You can find it at http://www.itninja.com/blog/view/k1000-service-desk-a-better-average-time-to-close-report
Please log in to comment

Answer this question or Comment on this question for clarity



This shows some of those methods, may be a good place to start. 


Answered 02/05/2013 by: jdornan
Red Belt

  • Thanks! That at least got me one step closer. Now I just need that SLA timer to work so it can be more accurate.
Please log in to comment