0

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

Helpful Unhelpful

1 of 2 people found this page helpful

Add a comment

You need to log in before you can submit a comment.

Need a password reminder?