This report outputs a count of tickets resolved by week of the year and by label:
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
Add a comment
Please log in or register to submit a comment.