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


添加一条评论

Please log in or register to submit a comment.

Need a password reminder?