Scripting

If you are trying to aggregate by year, month, queue, category, then try the following query as a starting point.  Modify as appropriate to your setup.  Note that our "months" run from the 25th to the 24th and is keyed to the ticket create date.  We also have custom fields for "FCR" (yes/no) and intake "channel" (single select with values like email, phone, in person, etc.).  Also, we are only interested in some of the queues for this report.

You can open the output in Excel and create a pivot table to slice, dice, and analyze.

I hope this helps.

SELECT
   CASE
 -- december to january
        when ( day(T.CREATED) in (25,26,27,28,29,30,31) and month(T.CREATED) = 12 ) then 1
-- add to month
        when ( day(T.CREATED) in (25,26,27,28,29,30,31) ) then month(T.CREATED) + 1
-- else just month
else month(T.CREATED) END as scorecard_month,
    CASE 
-- december to january
        when ( day(T.CREATED) in (25,26,27,28,29,30,31) and month(T.CREATED) = 12 ) then year(T.CREATED) + 1
-- else just month
else year(T.CREATED) END as scorecard_year,
    HD_QUEUE.ID,
    HD_QUEUE.NAME as 'Queue',
    HD_CATEGORY.NAME as 'Category',
    T.CUSTOM_FIELD_VALUE2 AS 'FCR?',
    T.CUSTOM_FIELD_VALUE1 AS 'channel',
    count(T.id) as 'Count'
FROM
    HD_QUEUE
INNER JOIN
    HD_TICKET T ON HD_QUEUE.ID = T.HD_QUEUE_ID
    INNER JOIN HD_CATEGORY ON T.HD_CATEGORY_ID = HD_CATEGORY.ID
where T.CREATED between '2013-05-25' and '2014-05-24' and
  HD_QUEUE.id in(1,4,5,7,8,9,10,12,13,14,16)
GROUP BY scorecard_year, scorecard_month, HD_QUEUE.NAME,HD_CATEGORY.NAME, T.CUSTOM_FIELD_VALUE2, T.CUSTOM_FIELD_VALUE1
ORDER BY scorecard_year, scorecard_month, HD_QUEUE.NAME,HD_CATEGORY.NAME, T.CUSTOM_FIELD_VALUE2, T.CUSTOM_FIELD_VALUE1;