Average custom field value by agent - انتقادات و پیشنهادات / 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

Please log in or register to submit a comment.