Gå till huvudinnehåll

Average time till first response - Kunskapsbas / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: Average time until first response

Average time till first response

Författarlista

An overall average time till first response report can be generated using the DPQL below:

SELECT AVG(tickets.total_to_first_reply / 3600) AS 'Average first response time in hours'

FROM tickets


For 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(tickets.total_to_first_reply / 3600) AS 'Average first response time in hours'

FROM tickets

WHERE tickets.date_created = ${date}


This data can be further grouped by agent , as shown below:  

SELECT AVG(tickets.total_to_first_reply / 3600) AS 'Average first response time in hours'

FROM tickets

WHERE tickets.date_created = ${date}

GROUP BY tickets.agent



Hjälpfull Oanvändbar

18 av 37 personer tyckte att sidan var användbar

Posta en kommentar

Logga in eller registrera dig för att lämna en kommentar.

Behöver du en påminnelse om ditt lösenord?