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

Comments

Please log in to comment

There are no answers at this time
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

Answer this question or Comment on this question for clarity