Skip to main content

Average resolution time of tickets - Tudásbázis / Developer & Reporting / DPQL Examples - Deskpro Support

Average resolution time of tickets

Authors list

To get a better understanding of the progress of  your team, it may be useful to generate a report that shows the average time taken to resolve tickets. 

An average resolution time  can be created using the DPQL format below:

SELECT AVG((UNIX_TIMESTAMP(tickets.date_resolved) - UNIX_TIMESTAMP(tickets.date_created)) / (60 * 60)) AS 'Average resolution time (in hours)'

FROM tickets


To look at a specific timeframe, a variable can be added, which allows the flexibility of choosing a specific timeframe. This can be done by first clicking on  'Add Variable' and filling in the details  as follows:


Once the variable is added, you could add a WHERE clause, which is used to limit the data displayed or used. In this example, a DPQL form can be written as shown below:

SELECT AVG((UNIX_TIMESTAMP(tickets.date_resolved) - UNIX_TIMESTAMP(tickets.date_created)) / (60 * 60)) AS 'Average resolution time (in hours)'

FROM tickets

WHERE tickets.date_created = ${date}


This data can be further grouped by agent and the final DPQL form is written as follows: 

SELECT AVG((UNIX_TIMESTAMP(tickets.date_resolved) - UNIX_TIMESTAMP(tickets.date_created)) / (60 * 60)) AS 'Average resolution time (in hours)'

FROM tickets

WHERE tickets.date_created = ${date}

GROUP BY tickets.agent


The final report should look like this:

Hasznos Nem hasznos

3 felhasználóból 2 hasznosnak találta ezt a cikket.

Kérjük ebbe a mezőbe írja hozzászólását, majd kattintson a 'Hozzászólás beküldése' gombra...

Please log in or register to submit a comment.

Need a password reminder?