Passer au contenu principal

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

22

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

Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Mot de passe oublié ?