Report on Aged tickets and Backlog report weekly.

21 Commentaires

  • Jennifer Rowe
    Actions pour les commentaires Permalien

    Ravi, this is awesome! Thanks for sharing it with the community.

    0
  • Szabolcs Szilagyi
    Actions pour les commentaires Permalien

    Does somebody know an option how to measure "open" (new, open, on-hold, but NOT in pending state) tickets' age? I mean I would like to create a report about those tickets what are opened longer than 8 business hours by our helpdesk, excluding that time when we are awaiting for customers.

    0
  • Brittany Fromm-Sarto
    Actions pour les commentaires Permalien

    Hi Szabolcs Szilagyi!

    You'd want to look at the metric Ticket Age (Open Tickets), which is New, Open, and Hold status. You can also add Ticket ID and Status. GoodData also has an article for this as well (see here).

    To incorporate business hours, you'd want to make an automation that tags tickets 8 hours after creation. Then you can add that to the report.

    You could also build a custom metric to measure this. We're not able to tell you exactly how to do it here in Support, but there are a lot of Insights resources available to you in the community. You can also make a request for that metric here. If enough people comment, we might be able to make a tip of the week!

    0
  • Rico
    Actions pour les commentaires Permalien

    Does anyone know of a way to get backlog broken down by product? I've not found a way to do this since "product" is a custom field. 

    0
  • Solène Regnier
    Actions pour les commentaires Permalien

    Hello rdimarzio,

    You can actually create reports based on custom fields. There are imported as different objects in GoodData depending on their types. For more details about that you can check the following article:
    https://support.zendesk.com/hc/en-us/articles/203662446-Reporting-on-custom-fields-in-Insights-Plus-and-Enterprise-#topic_fgt_12c_54 

    I hope that helps!

     

    0
  • Rico
    Actions pour les commentaires Permalien

    @Solene,

    Thank you for the input, but I have to admit, I'm understanding how to use this data. If opening a support ticket is the correct way to get help on this subject, I'd be happy to do so. 

    0
  • Karyn Tooke
    Actions pour les commentaires Permalien

    Is it possible to generate a report that shows the age of a ticket at a point in time such as daily, weekly or monthly?

    1
  • Andrei
    Actions pour les commentaires Permalien

    @Rdimarzio,

    I've looked further into that workflow and unfortunately that would be quite difficult to implement. The problem here is that the backlog report is in a completely different section in the data model than where the custom field that you created would be. So while we can create reports on custom ticket fields and reports on backlog data, getting the two to work together would not be possible at this time.

    @Karyn,

    Reports are updated when a specific event happens or actions the ticket, until that point no data is written. So unfortunately your ideal report would not be possible to create. The limitation of Good Data is that it does keep running totals of any specific metrics. Specifically with the ticket age metric changing the ticket status for example should update the event in question.

    0
  • Eshmeet Singh
    Actions pour les commentaires Permalien

    Current ticket aging report throws result in calendar days, could you please help me create the same report in business days?

    Thanks

    Eshmeet

    0
  • Jessie Schutz
    Actions pour les commentaires Permalien

    Hi Eshmeet!

    If you look in the Backlog Week on Week section of this article and go to step 3, you'll see a screen shot of what building this report looks like.

    Click where it says Click to select specific values, and choose the days you want included in the report. That should take care of it!

    0
  • Christopher J. Crocker
    Actions pour les commentaires Permalien

    Hi,

    I've search in Zendesk comunities, KB, and in GoodData MAQL doc.   I am struggling to find an answer to this question...

    I am using the following MAQL statement:

    SELECT # Unsolved Tickets WHERE ( SELECT Ticket Age (Days) [AVG] BY Ticket Id ) between 30 and 60

    Does the "between" act as an inclusive here?  Meaning will I return a count of the tickets that are aged 30 to 60 days "inclusive"?  or will this return starting at age 31 days to 59 days?

    If the MAQL "between" is not inclusive, is there an alternate MAQL clause/syntax that would be inclusive?  or do I simply change my statement to be between 29 and 61 ? 

    0
  • Billy Macken
    Actions pour les commentaires Permalien

    Hi Chris,

    I can confirm, when using BETWEEN, the two date range end points are inclusive:

    https://help.gooddata.com/display/doc/BETWEEN  

    I hope this helps! Happy reporting!

    2
  • Kriti Anand
    Actions pour les commentaires Permalien

    Hi Guys, I had just one question, while running the code provided, I am getting Unknown object (uri: AVG). Could you please help me here

    0
  • Christopher J. Crocker
    Actions pour les commentaires Permalien

    Hi Kriti,

    Are you using the metric in Zendesk Insights?

    AVG is in the name of the metric used for this.

     

    0
  • Heather Lange-Wilson
    Actions pour les commentaires Permalien

    Jessie - 

    You refer to a screenshot under step 3 of Backlog week by week, however I am not seeing any screenshot.

    0
  • Jessie Schutz
    Actions pour les commentaires Permalien

    Hi Heather!

    Hm, it looks like the image broke since my last comment. This is a Tip generated by one of our community members so I can't guarantee that we'll be able to replace it, but I'll try!

    0
  • Chase Redfield
    Actions pour les commentaires Permalien

    @ Jessie

    I am also running into the same issue with the missing screenshot! Any help you can provide would be great as currently I am showing the screen below but I assume that the filter will get around this. 

     

    Even if we don't get the screenshot back, knowing what filter to apply should be enough. 

     

    Thanks!

    0
  • Nick LaColla
    Actions pour les commentaires Permalien

    The screen shot in #3 of Backlog Week on Week appears to be mission.

    0
  • Jessie Schutz
    Actions pour les commentaires Permalien

    Hi everyone!

    I apologize for the inconvenience on this. I'm working finding someone who might be able to help.

    As I mentioned before, this is a Tip written by a Community Member, which means that we don't have access to the original images that they posted. If those images become unavailable for some reason, we don't have a way of retrieving them and we have to rely on other Members to volunteer to re-create the images or the entire tip.

    Be assured that I'm looking into this, and I'll let you know if I come up with a fix.

    0
  • Taimur Saad
    Actions pour les commentaires Permalien

    Why was Tickets days Avg was used instead of Ticket days open?

     

    thanks

    0
  • Brett - Community Manager
    Actions pour les commentaires Permalien

    Hi Taimur,

    The Ticket Age (days) [AVG] metric will look at the average number of days between the ticket created date to the present BY ticket ID WHERE deleted tickets are not included. This will include tickets regardless of status where as Ticket Age (Open Tickets) will not include any tickets in the Deleted, Solved, or Closed statuses.

    If you want to exclude solved tickets from this metric then you can certainly use Ticket Age (Open Tickets) instead.

    Hope this helps!

    0

Vous devez vous connecter pour laisser un commentaire.

Réalisé par Zendesk