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'
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.