Skip to main content

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


Average custom field value by agent Report

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

Add a comment

Please log in or register to submit a comment.

Need a password reminder?