/build/static/layout/Breadcrumb_cap_w.png
08/23/2019 142 views

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

Comments

  • Do you just want a count of tickets opened or broken down by month, etc.?
  • Yes, a count broken down by month for open and closed.

All Answers

0

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)


Answered 09/05/2019 by: chucksteel
Red Belt