KACE Product Support

The following query returns for the previous three months, which is a quarter. You should theoretically be able to use the QUARTER function in MySQL to make the more elegant, but this should work:

 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 date_format(NOW() - INTERVAL 4 MONTH, '%Y-%m-01') AND last_day(NOW() - INTERVAL 1 MONTH)
AND HD_TICKET.HD_QUEUE_ID = 2
GROUP BY HD_TICKET.HD_CATEGORY_ID

Be sure to change the HD_QUEUE_ID to match the queue that you are running the report for.

Im late to the party but meh,

select case
           when MONTH(T.CREATED) between 1 and 3 then '1st Quarter'
           when MONTH(T.CREATED) between 4 and 6 then '2nd Quarter'
           when MONTH(T.CREATED) between 7 and 9 then '3rd Quarter'
           when MONTH(T.CREATED) between 10 and 12 then '4th Quarter'
       end as QUARTER,
       C.NAME,
       COUNT(T.ID) as NUMBER_TICKETS
from HD_TICKET T
join HD_CATEGORY C on T.HD_CATEGORY_ID = C.ID
where T.HD_QUEUE_ID = 1
  and YEAR(T.CREATED) = YEAR(CURTIME())
group by QUARTER,
         T.HD_CATEGORY_ID
order by QUARTER asc