Report to show Count of Tickets Opened in given month
With the help of Chris G, I was able to show how many tickets were opened for a given category in a given month. Its very helpful in tracking yearly or quarterly reports to show trends.
SELECT HD_CATEGORY.NAME AS 'Category Description', COUNT(HD_TICKET.TITLE) as 'Count of Tickets'
FROM ORG1.HD_TICKET, ORG1.HD_CATEGORY
WHERE HD_TICKET.HD_CATEGORY_ID = HD_CATEGORY.ID AND (HD_TICKET.HD_QUEUE_ID = 1) AND (HD_TICKET.CREATED like '2011-10%') AND (HD_TICKET.TIME_OPENED > 0)
group by HD_CATEGORY.ID
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
