Insights metrics reference (Professional and Enterprise) Follow

Comments

18 comments

  • Avatar
    Tom Kippenberger

    From the descriptions, it looks like the three Ticket Age metrics all keeping counting even when a ticket is solved of closed. They do a comparison to 'Present' rather than to 'Closed Date'. Is this correct?
    Ticket Age (days) [AVG]
    Ticket age (days) [MAX]

    Ticket Age (Open Tickets)

    I would be more interested in:
    Average age of Unresolved tickets
    Average age of Tickets when Solved
    Average age of all tickets (combination of the above)

    Does anyone else have an example of these?

  • Avatar
    Brent

    Hi Tom,

    You are correct - Ticket Age (days) [AVG] and Ticket age (days) [MAX] will measure the age of a ticket from the day it was created to today, regardless of its status.

    Making custom metrics for your own needs based on the default metrics should be pretty straightforward:

    • Average age of Unresolved tickets: Take the "Ticket Age (Open Tickets)" metric, make a new copy of it, and replace "MAX" with "AVG" in its MAQL.

    • Average age of Tickets when Solved: I duplicated the "Ticket Age (days) [AVG]" metric and modified it slightly to calculate the number of days between the date a ticket was created and the date a ticket was solved:

    SELECT AVG(SELECT Date (Ticket Solved) - (SELECT Date (Ticket Created) BY Ticket Id)) WHERE Ticket Status IN (Closed, Solved)

    • Average age of all tickets - The default metric "Ticket Age (days) [AVG]" might be what you're looking for here. It measures the time between when tickets were created and today.

    Otherwise, if you mean you want to combine the average age of unsolved tickets (today minus Date (Ticket Created)) and the average age of the tickets when they were solved (Date (Ticket Solved) minus Date (Ticket Created)), I don't think that is possible with Insights. My best recommendation in that case is to use the two metrics I described above side-by-side on a dashboard and compare them.

    Hope that helps! Please let us know if we can be of further assistance or if you'd like more detail on how to make the metrics.

  • Avatar
    Bianca Russelburg

    Hi there!

    My team uses an open-pool ticket system where, once re-opened with a response from the requester, it goes back into the unassigned pool. Because of this system, many tickets get "Solved" more than once, often by different Agents. Does "# of Tickets Solved" include multiple Solves on the same ticket? Or does it just count once + get attributed to that person?

    Thanks!

  • Avatar
    Alex Aguilar

    Looking through the metrics, I've noticed there are two types of solved ticket metrics.

    What's the difference between how these work. I'm having trouble understanding the first one.

    1. # Tickets Solved

    SELECT IFNULL(COUNT(Ticket IdTicket Text Field Change), 0) WHERE [Text Field] New Value IN ([Status] solved[Status] closed) AND [Text Field] Previous Value <> [Status] solved AND Ticket Status IN (SolvedClosed) AND Date (Event) = (SELECT MAX(SELECT Date (Ticket Solved) BY Ticket Id) BY Ticket Id)

    2. # Solved Tickets

    SELECT # Tickets WHERE Ticket Status IN (Solved,Closed)

  • Avatar
    William Macken

    Hi Alex!

    Functionally, there isn't any difference between the two metrics. The longer definition in the first metric allows solved tickets to be sliced by Event date attributes in addition to Ticket Solved date attributes. This is so the results from the # Tickets Solved metric would make sense alongside other metrics that might not make sense using Ticket Solved date attributes.

    I hope this helps-- Happy reporting!

  • Avatar
    Daniel Yousaf

    Hi Bianca!

    # Tickets Solved only sees the final solve on a given ticket. Who gets the credit depends on how you slice it!  If you use Ticket Assignee (Historic), it'll attribute the solve to the first assignee on the ticket.  If you use Ticket Assignee, it'll attribute the solve to the ticket's assignee when the ticket was solved.  And if you use Updater, it'll attribute the solve to the person or process that updated the ticket to Solved.

    Thanks for your question!

  • Avatar
    Gurunn

    Hi,

    If I look at number of group stations for a specific group does the number mean the number of tickets that have ended up in the group? Or the number of tickets which has left the group?

    e.g 1st line # of group stations is 56. Is the number showing number of tickets that has been moved from 1st line or tickets being moved into 1st line?

  • Avatar
    Monica Aten

    Hi Team,

    Our group is trying to create a report that shows the % of tickets created and solved by agent. Basically we are trying to measure the amount of work each agent is doing on a weekly basis.

    I already have a report that shows me # of Tickets Solved and # of Tickets Created by each agent, but I don't know how to switch the results to a percentage. 

    Any suggestions?

    Thanks!

  • Avatar
    Leah (Edited )

    Hi Monica!

    For this, you’ll need to create a custom metric. If I understand you correctly, you’ll need to create two different metrics: one for % Tickets Created and one for % Tickets Solved. The metrics you want are:

    SELECT # Tickets Solved/ (SELECT # Tickets Solved BY ALL OTHER)

    and

    SELECT # Tickets Created/ (SELECT # Tickets Created BY ALL OTHER)

    For your report, you’ll select these two metrics and then select Ticket Assignee under the How section. The report will show a distribution of how many tickets are created and solved for each of your assignees by percentage.

  • Avatar
    Stephen Fusco

    Hey Gurunn, 

    When you create a report for Group Stations by Group Name the number you're seeing is the # of tickets that have been changed to that group. 

    Thanks for your question! 

  • Avatar
    Jill Gala

    Hi, 

    I am trying to create a report for the number of tickets that have been changed from a particular ticket group to another ticket group. I know the names of both the ticket groups.  

    Any suggestions on how this can be created?

    Thanks in advance!

  • Avatar
    Jessie Schutz

    Hey Jill!

    This is an interesting question...let me see if I can get some of our Insights gurus in here to help you out!

  • Avatar
    William Macken

    Hi Jill!

     

    I would recommend checking out our article on Building custom metrics for the events model-- you're going to want to specify the groups you're interested in using the [Text Field] New Value and [Text Field] Previous Value attributes to pull tickets that had an update submitted that changed groups in the way you've specified.

     

    I hope this helps! Happy reporting!

  • Avatar
    Graeme Carmichael

    Jill

    That is a really good suggestion for a metric.

    Here is an example of counting the number of times the group is changed from the development group to the support group.

    If you have not created custom metrics before, please follow the link provided by William. You must use the element selector from the right hand pane to enter the fields and field values.

  • Avatar
    Diogo Silva

    Hi.

    Im missing the option in the image. Why my zendesk don't give me this? I need it to create a report. Can someone explain?Best regards!

     

  • Avatar
    Warren Balmaceda

    Hello there,

    Please shed some light on how to get the percentage of total Solved Tickets in First Reply Time (hrs) [Avg], First Resolution Time (hrs) [Avg] & Full Resolution Time (hrs) [Avg] per group and per agent. 
     
     
    e.g. Total solved tickets for the month of September is 4,500.
     
    What are the percentages of the total solved tickets using the above metrics,
    per agent and per group?
     
    Thanks in advance.
  • Avatar
    Patrick Bosmans

    Hello Diogo,

     

    I am going to be sending you a ticket shortly so that I can get some more information about your account.  

    We can continue our conversation there!

  • Avatar
    Bryan Flaherty (Edited )

    Hello Warren,

    I'd like to gather a bit more information about your reporting needs.  I'd like to pull your request into a ticket and see if we can get your question answered!

Please sign in to leave a comment.

Powered by Zendesk