Filtering for follow-up tickets

4 Comments

  • Violeta Micu
    Comment actions Permalink

    Hello,

    There are 2 ways to see the Follow up tickets in explore.

    Dataset: Ticket Events

    1. This solution helps you to see quickly how many follow-up tickets you have:

    Metrics: Tickets created

    Filters: Update channel

    Attribute Values: Closed Ticket

    2. This one will help you to have one defined metric for follow up tickets. In this case you would be able to add other metrics to compare, like total created tickets :)

    Define Standard calculated metric:

    IF ([Changes - Field name]="status" AND [Changes - Previous value]=NULL)
    AND [Update channel]="Closed Ticket"
    THEN [Update ID]
    ENDIF

    After creating the metric you will use COUNT instead of SUM

    I compared the data with the one from Insights and it seems correct.

     

    Happy reporting!

    Vio

    1
  • Molly
    Comment actions Permalink

    Hey Chloe,

    Welcome to The Community! To filter for reopens in Explore, you can use the Reopens Bracket and exclude or include the number of reopens as per your preference:

     

    0
  • Pedro Rodrigues
    Comment actions Permalink

    The reply above is a bit misleading... Reopens seems to refer to Solved tickets whose update reopens them, i.e. their status changes to Open (source article; "Reopened Tickets: The percentage of reopened tickets that were previously marked as Solved.")

    One way of reporting on follow-up tickets, for example:

    • Trigger 1. When ticket is updated AND status changes to Closed = add tag ticket_closed
    • Trigger 2 (placed at the very top of trigger list). When ticket is created AND tag = ticket_closed = remove ticket_closed + add ticket_followup

    To report on follow-up tickets, you now have the tag 'ticket_followup'.

    (Instead of a tag, you could have a checkbox or some other field, of course.)

    0
  • Pedro Rodrigues
    Comment actions Permalink

    Awesome, thanks Violeta!

    0

Please sign in to leave a comment.

Powered by Zendesk