K1000 Reporting: Monthly Report for Average Ticket Time by Owner and Location
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.