Need help adding a line of code to this existing K1000 report
I need to add a line to this report with the ticket totals for the month....
The code below and I added a screen shot of the report. 
select HD_CATEGORY.NAME, COUNT(HD_TICKET.ID)
from HD_TICKET
JOIN HD_CATEGORY on HD_TICKET.HD_CATEGORY_ID = HD_CATEGORY.ID
Where HD_TICKET.TIME_CLOSED BETWEEN '2014-02-01' AND '2014-02-28'
AND HD_TICKET.HD_QUEUE_ID = 1
GROUP BY HD_TICKET.HD_CATEGORY_ID
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
