Passer au contenu principal

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

16

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


Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Mot de passe oublié ?