Insights recipe: Reporting on duration of a text field Follow

Comments

14 comments

  • Avatar
    Johann

    Hi there - it's really a great article but unfortunately  I am struggling to adjust it to my needs. I am looking for the number of hours a ticket is assigned to an agent (that is not closed, solved or deleted). Somehow it doesn't show any results if I follow the steps like with the group example. Could you please help?


    Thanks

  • Avatar
    Eugene Orman (Edited )

    Hi Johann,  

    The metric which you need to use in this case will look like this:

    I tried this metric on my test account and can confirm that it returns expected results. Here is a report example:


    I have created the ticket #1790068 for you in case you'll need more assistance on this case. 

    However, there is a downturn when the "[Text Field] Duration in minutes" fact is used for reporting on Text fields, which are not updated so frequently throughout the ticket live.  

    For example, "Assignee" field might be updated just once on a ticket, in this case, this fact will return a null value. Since it counts the time between 2 text field changes, there should be minimum 2 field updates on the ticket in order to capture the time duration. 

    To avoid this you can use metric logic described in Duration between two or more ticket events in minutes article. 

     

  • Avatar
    Pete Holborow

    I was directed to this article by support who suggested it could solve my question on how to report on how long (on average) our tickets are spending in each status before being solved.

    I'm not great with MAQL, how would I go about starting this?

    Thanks

  • Avatar
    Matteo Larocca

    I think the recipe "How long are tickets sitting with my support groups?" is not correct.

    In fact, if I filter the report to just one ticket ID and the ticket moved from G1 to G2, the report just show me the duration on G1. No line for G2 group.

     

    I suppose this is due to lack of event where previous group value was G2 and so no duration is computed.

    But I think there should be a way to have this report complete and correct, but I can't figure out how.

    Any suggestion?

  • Avatar
    Greg

    Hi Matteo...would you mind clarifying what you are expecting in this scenario? The report in question will show you the amount of time a ticket spent in a previous group, so if the ticket is still within G2 and nothing has happened since it's been there, there is no event to calculate any elapsed time.

  • Avatar
    Matteo Larocca

    Hi Greg,

    the recipe states "You can answer questions like: How long are agents holding on to tickets? How long do tickets take to cycle through each of your Support Levels?"

    I can't find a way to have a complete report to answer the second question. How long, on avarage, a support group holds a ticket?

    Since the duration is computed when the ticket group changes, no duration is provided for the last group on the ticket life cycle (the group that has the ticket when it is finally closed).

    Do you have a way to have this kind of report?

    Thank you

    Matteo

  • Avatar
    Greg

    Hi Matteo,

    I agree that the wording leaves a bit of ambiguity in this recipe and I will pass this to our Documentation team to review this. That being said, if the ticket has not left the final group, there would be no way to report on this with the above metrics. I wish that there were a better answer for this scenario, but there is not going to be a way to handle a calculation of an event that has not yet occurred.

  • Avatar
    Anthony Garcia Jr.

    Hello! I was referred to here by one of your email support representatives when I tried to seek help about creating a custom macro where the amount of time tickets spend on New status is measured. 

     

    My idea is to deduct the amount of time spent on New status from the Requester Wait Time metric. This is so I can measure the amount of time our agents have spent on working on tickets. 

     

    Any advice on this matter will be greatly appreciated. 

  • Avatar
    Heni Anis

    Hi , 

    I Have the same question as Pete Holborow Could you please help us ?

    I need a the average time spent on each status of the ticket before it get solved.

    Thanks you.

  • Avatar
    Nicole Relyea

    Hey guys - 

    Zendesk Support can't build custom metrics for you (which is why they sent you to the community) but there are a lot of smart and helpful people here. I'll try to ping a few folks to see if they can weigh in and help you out. 

  • Avatar
    Pete Holborow

    Nicole that would be perfect thank you.

  • Avatar
    Heni Anis

    Thank you we really need it , that will be helpful not only for us .

    Thanks again.

  • Avatar
    Nicole Relyea

    Okay, I've pinged our moderator team to see if any of them have suggestions. 

  • Avatar
    Graeme Carmichael

    The average time in each status is tricky as one ticket can move into the same status multiple times or have no instances of a status.

    For average time in minutes, I would go for:

     

Please sign in to leave a comment.

Powered by Zendesk