Skip to main content

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

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

コメントを追加

コメントを投稿するには、ログインまたは登録が必要です。

パスワードをお忘れですか?