Insights recipe: Measuring the number of incidents by problem Follow

Comments

9 comments

  • Avatar
    Justin

    Any way to include the Problem ticket's subject in this report?

  • Avatar
    Josh Rosenthal

    Hi Justin,

    In this report the metric is only measuring incident tickets so only data about those tickets is available.

    In order to add the subject of the problem tickets, you would need to use a metric that includes the problem ticket data.

    Building reports is normally outside the scope of what Support assists with however,
    I did a quick test and added the # Problems metric in What, and Ticket Subject in How, which does show the problem ticket subjects, but this also displays the subject of the incident tickets. 

    Hopefully you can build from that and get what you are looking for, but please don't hesitate to ask more questions!

     

  • Avatar
    Trent Upton

    Josh - could you give some direction on building out said metric? We are looking for way that we can track total time spent on problems but want to be able to see the ticket subject for the problem ticket. 

  • Avatar
    Jessie Schutz

    Hey Trent! Sorry for the delayed response here. I'm checking with some of our Moderators to see if someone can help with this!

  • Avatar
    Giovanni BERTHELOT

    Hey, 

    Do you have any update on this ?

    It could be really, reaaaally helpful.

  • Avatar
    Jessie Schutz

    Hey everyone!

    Apologies for the delayed response. Our Community Moderators are Zendesk users like you, and sometimes they get really busy with their day jobs! I've pinged them again to see if someone is available to help. :)

  • Avatar
    Fernando Duarte

    Simply add Ticket Subject as part of the WHAT.

     

    I would also recommend adding a filter as follows:

     

  • Avatar
    Giovanni BERTHELOT (Edited )

    Hi,

    Thanks a lot for your reply Fernando !

    Doesn't work on my side unfortunately.


    What :

    • #incident

    How : 

    • Ticket Problem
    • Ticket Subject


    Filter :

    • Ticket Problem isn't (empty value)

     

    ---

     

    With this recipe I get something like this : 

     

    As you can see, here I have the ticket subject of every incident tickets, not the subject of the Problem ticket.

    What I try to build is a tab with :

     

    • The ticket ID of the Problem ticket (to be able to click on it)
    • The subject of the Problem ticket
    • The # of incidents linked to this problem ticket.


    Thank you for your time and for your help.

    Cheers,

    Giovanni

     

  • Avatar
    Justin

    @Giovanni,

    Sadly in all my efforts I could not get this to work with default GoodData/Insights. I even built custom MAQL queries to attempt to link the Problem subject to the incident count, however I always ran into trouble as the ID of the ticket, doesn't appear to be the actual ID in the Database. 

    I really wish we could just write our own SQL.

    Until Zendesk Insights adds support for this I have resorted to writing my own basic Zendesk App to display what I need.

Please sign in to leave a comment.

Powered by Zendesk