Count of tickets resolved by week of year and by ticket label - Community / DPQL Reports - Deskpro Support

Count of tickets resolved by week of year and by ticket label Report

This report outputs a count of tickets resolved by week of the year and by label:

SELECT DPQL_COUNT()

FROM tickets

WHERE tickets.status IN ('resolved', 'archived') AND tickets.date_resolved = %THIS_YEAR%

GROUP BY DPQL_MATRIX(tickets.labels.label, DPQL_ALIAS(DATE_FORMAT(tickets.date_RESOLVED, '%u'), 'Week resolved'))

We're using DPQL_MATRIX here to allow us to split the data along two fields.

Read more about this function in our guides

Please log in or register to submit a comment.