Time Tracking app: metrics you need to be measuring

Have more questions? Submit a request

54 Comments

  • Lennart Schmidt
    Comment actions Permalink

    We can not choose the dataset "Support: Ticket Updates". The "Zendesk support" does not have this option too. We can only choose between "Support: Ticket Events" and "Support: Tickets, Users, Organizations". How can we get the right dataset?

    2
  • Eugene Orman
    Comment actions Permalink

    Hi Lennart, 

    Support: Ticket Events is the legacy name of the Support: Ticket Updates dataset. Its content is exactly the same. So, in your case, you can create the metrics listed above in the Ticket Events. 

    In future "Ticket Events" will be renamed into  "Ticket Updates".

    0
  • Lennart Schmidt
    Comment actions Permalink

    Hi Eugene,

    then we chose the right dataset. If we configure it as you say in your instruction, we got this exception:

    0
  • Eugene Orman
    Comment actions Permalink

    It means that there is an issue with the syntax of the metric. Probably you used different metric names but forgot to update the related metric formula according to the names you had set. I will create a ticket for you to check this. 

    0
  • Lennart Schmidt
    Comment actions Permalink

    We have an german client and need to take take the german expressions... Now it works. Thanks for your help.

    0
  • Phil Shackleton
    Comment actions Permalink

    Hello, can you tell me how we could round the time tracking values to the nearest 15 minutes?

    0
  • Gretchen Ladd
    Comment actions Permalink

    Hey Phil!

    For this scenario you would actually need to create a calculated attribute using one of your Time Tracking - min metrics. It would look something like this:

    IF (VALUE(Time Tracking Metric- min) <= 15)
    THEN “0-15 min”
    ELIF (VALUE(Time Tracking Metric- min)>15 AND VALUE(Time Tracking Metric- min) <= 30)
    THEN “15- 30 min”
    ELIF (VALUE(Time Tracking Metric- min)>30 AND VALUE(Time Tracking Metric- min) <= 45)
    THEN “30-45 min”
    ELIF (VALUE(Time Tracking Metric- min) > 45)
    THEN “>45 min”
    ELSE “No update”
    ENDIF

    Where (Time Tracking Metric- min) is a placeholder for whichever metric in minute dimensions you want to use. I'm not sure if this is exactly what you're looking for but this is about as close as we can get.

    More on calculated attributes here:

    Hope this helps!

    0
  • Boyan Parshorov
    Comment actions Permalink

    Dear Eugene Orman ,

    Can you please advise if there is a way for me to create a Time tracking by Group report?

    For Example: When a ticket is received in "group A" they make some changes for 3h and assign it to "group B" for 2h, then they assign it to "group C" for 1h and they close it.

    So the report should look like:

    Ticket id           Group A             Group B                  Group C         Total resolution Time

    123345                3h                         2h                         1h                         6h

    132665                1h                         2h                         3h                         6h

    Please help me to achieve this.

    Thank in advance.

    1
  • Tim McMacken
    Comment actions Permalink

    Hey Eugene and the ZD Team,

     

    I am struggling to get the time tracking to work at all. I have had the time tracking app active since the beginning of February, but I am not getting any tracked tickets with these queries.

     

    How can I get this working? I need it for reporting asap. Thanks!

    0
  • James Sanford
    Comment actions Permalink

    Hey Boyan!

    You can achieve this Time Tracking by Group report with the following:

    Metrics: Sum(Update Handling Time - min)

    Columns: Update Ticket Group

    Rows: Ticket ID

    A Simple Total result manipulation for the Sum of columns will allow you to include your Total resolution time (based on the time tracking data).

    (please note that the Update Ticket Group filter in my example is only included for clarity and may not be necessary for your purposes)

    0
  • Whitney Puidokas
    Comment actions Permalink

    Does handle time start when the ticket changes from New to Open or when the first agent comment occurs?

    0
  • Mark Adkins
    Comment actions Permalink

    These metrics are displaying aggregated time.   How do we go about calculating a metric we can use per agent to show during a specific time period how much time they spent on a ticket?  What I mean is, the update handling time may show you the last update this week, but then the total time is showing not the total time this week, but the total time - from all time.  How do you fix this?   I'm trying to create an agent productivity report showing how much time each agent spent on specific tickets during a week

    0
  • Eugene Orman
    Comment actions Permalink

    @Whitney,  the handling time is recorded at each agent comment submission. The timer starts counting once the agent accesses the ticket and ends when the update is submitted. So, it is independent of the ticket status field.  

    @Mark, you can simply slice the SUM(Update handling time) metric by the Updater Name and filter it by the specific time range. So, the report will be very similar to the Example 3 from this article, but you will use the SUM aggregator instead of AVG. 

    0
  • Gab
    Comment actions Permalink

    Hi Whitney, hi Mark,

    Eugene's right! @Whitney, the handling time is measured between the time the agent opens a ticket, and clicks on submit. 

    @Mark, just follow Eugene's instructions and you'll get the data that you need on agent handling time :-)

    Thank you, Eugene!

     

     

    0
  • Paul Bendzko
    Comment actions Permalink

    Hi guys,

     

    when i copy and paste the above i get an error message and i am therefore not able to get the AHT displayed.

    Any tipps?

     

    Thanks

    Paul

    0
  • Eugene Orman
    Comment actions Permalink

    @Paul, If your user profile language is not in English replace the attribute names in the formula with attributes in your language. As well, check if the attributes you need exist in the dataset you are using.

    0
  • Johann Lazarus
    Comment actions Permalink

    With regards to Example 1 - we can have sometimes up to 3 people working on different activities in a single ticket for a customer.

    What do I need to do in order to show for a particular ticket which of my team members worked on a the ticket and the time they each expended?

    1
  • Segio Daniel Hernández
    Comment actions Permalink

    Hi guys!

    Thank you for the recipes! Im wondering if there's a way to know how many time a ticket spent in a status?

    i.e. How many time our tickets spent in hold or pending?

    And in which tickets a trigger made changes?

    Thank you in advance :)

    1
  • Harvey
    Comment actions Permalink

    Hey Team, 

    Thanks for creating so many great recipes for us to use! I did want to ask if you could direct/help create a recipe I am looking for. I am interested in Public Comments per Ticket for a specific channel. I would be interested in seeing the average across the channel. Would love to hear if this is possible. 

    Thanks! 

    0
  • Carla
    Comment actions Permalink

    Hi,

    Is it possible to calculate the ticket handling time from a report like this, per quartiles?

    Thanks!

    0
  • James Sanford
    Comment actions Permalink

    @Johann!

    It looks like you're trying to use Example 1 for a use case that it is not intended for.  Example 3 is more in line with what you are looking to report on to expose the update handling time spent per Agent.

    @Segio

    The Ticket Updates dataset includes metrics for Duration - Field changes you can use for this purpose.

    If you wish to see which Tickets a Trigger fired on you would need to update the Trigger to add a specific data point (such as a Tag) and then report on which Tickets contained that Tag.  Trigger usage cannot be reported on in Explore without these changes.

    @Harvey

    You can report on Public Comments per Ticket by Channel with this configuration using the Ticket Updates Dataset.  

    You would then need to add a Result Manipulation for Totals with the Average aggregator to achieve your desired results.

    1
  • Carla
    Comment actions Permalink

    Hi,

    Is Tymeshift integrated with Zendesk Explore?

    Does anyone know if it is possible to get agents' working time in Zendesk Explore? I mean All of the time logged for the agent, by excluding Lunch from occupancy?

    Thanks!

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hi Carla,

    Tymeshift is a 3rd party integration so you'll actually want to reach out to them directly to discuss whether it's compatible with Explore or not. You can contact them at the following email address for further assistance: support@tymeshift.com

    Hope this helps!

    0
  • Carla
    Comment actions Permalink

    Thanks Brett!

    What about my previous inquiry?

    0
  • Mistyamber Reynolds
    Comment actions Permalink

    For "Ticket Handling Time (min)" how do I get it to show actual time in minutes and seconds?  I don't want it to round

    0
  • Eugene Orman
    Comment actions Permalink

    @Mistyamber, simply use the SUM aggregator instead of AVG. See Choosing metric aggregators for more details. For minutes you can use Ticket handling time (min) calculated metric and Total time spent (sec) custom field metric for seconds.

    0
  • Rolly Valenzuela
    Comment actions Permalink

    Hi All-

     

    Just activated the Time Tracking app hours ago. Trying to show the "Ticket Handling Time" per ticket by assignee name but no success. Please help 

    I just want to get the min spent per ticket.

    1
  • Jared Allenbrand
    Comment actions Permalink

    I am trying to do that also, instead of generic time but finding out actual values using the time tracking app. 

     

    0
  • Colum Wedel
    Comment actions Permalink

    Hello,

    We have Support Professional, which entitles us to Explore Lite.

    We want to know if it is possible to get metrics from the Time Tracking app on Explore Lite. For instance, time per ticket, total time accrued by tickets from a particular organisation, etc.

    Any info?

    TIA guys!

    0
  • Eugene Orman
    Comment actions Permalink

    Rolly Valenzuela, the Time tracking app data will start flowing into Explore once the app is used on some of the tickets. Tickets that were closed before you installed the app will not have any ticket handling data. 

    Jared Allenbrand, If you want to see values submitted per ticket you can use the same approach as Rolly. Simply create a query in the Tickets datasets. You can even use the original metric to see the raw data in seconds recorded by the app. Here is a demo - https://cl.ly/e38494a0ccfb

    Colum Wedel, Since Explore Lite doesn't provide the ability to create custom reports displaying the Time tracking app data is not possible. You need to be on Explore Pro to access this data. 

    0

Please sign in to leave a comment.

Powered by Zendesk