Skip to main content

Average custom field value by agent - DPQL Reports - Deskpro Support

This DPQL returns an average for a custom ticket field which conatins a number (be sure to replace # with your field ID):

SELECT AVG(tickets.custom_data[#]) AS 'Average field value'

FROM tickets

WHERE tickets.custom_data[#] <> NULL

GROUP BY tickets.agent


 We're simply applying the AVG MYSQL function to the custom field to show its average value per agent


コメントを追加

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

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