Прескочи към главното съдържание

Average resolution time of tickets - База знание / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: Average Ticket Resolution Time

Average resolution time of tickets

Списък с автори

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:

Полезно Не беше полезно

19 от 37 души смятат тази страница за полезна

Добави коментар

Моля, логнете се или се регистрирайте, за да оставите коментар.

Нуждаете се от подсещане за парола?