K1000 Service Desk custom report question
Has anyone setup a custom report to display amount of total tickets opened / closed for the year based on a category name or title of the ticket?
Looking to get some data on our new hire tickets.
Thanks!
2 Comments
[ + ] Show comments
-
Do you just want a count of tickets opened or broken down by month, etc.? - chucksteel 5 years ago
-
Yes, a count broken down by month for open and closed. - boston491 5 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
5 years ago
This is what I use:
SELECT YEAR(CREATED) AS TicketYears, MONTH(CREATED) AS TicketMonths, COUNT(ID) AS "Opened",
(SELECT COUNT(ID) FROM HD_TICKET WHERE YEAR(TIME_CLOSED) = TicketYears and MONTH(TIME_CLOSED) = TicketMonths) AS "Closed"
FROM ORG1.HD_TICKET
GROUP BY YEAR(CREATED), MONTH(CREATED)
