Ticket tags attribute in a report | Community
Skip to main content

Ticket tags attribute in a report

  • May 5, 2023
  • 4 replies
  • 0 views
Irene11
I made a report to get a list of emails and ticket IDs that have given us a good satisfaction rating, and I want to exclude all tickets that have the tag "XYZ".
 
However, as soon as I add the attribute "Ticket Tag" the emails get duplicated and I get the same email address several times. The problem continues if I select exclude "XYZ".
 
I have tried changing the metric "Good Initial Satisfaction" to DCOUNT so that I only see each result once, but that doesn't make any difference.
 
Any idea of how I can get around this so that each email only shows once when I use the tag attribute? And to make the exclude "XYZ" option work?
 
 
Thanks!

    4 replies

    David18
    • David18
    • May 5, 2023

    Hey Irene,

    Filtering by tags is funky in Explore and doesn't work how I (or you) would expect it to. The way I get around this issue is to create a Custom Attribute which I then add as a filter to include/exclude tickets with a particular tag.

    So, in your case, I would create an attribute something like this:

    IF (INCLUDES_ANY([Ticket tags], "XYZ"))
      THEN "Has XYZ tag"
      ELSE NULL
    ENDIF

    Then you can add the attribute to the filters at the top of your report, click on it and click on "NULL" (if you have the "Selected" button highlighted) or click on "Has XYZ tag" (if you have the "Excluded" button highlighted). Either option should get you where you want to be. 

      G
      • Gabriel32
      • May 7, 2023
      Hi Irene,
       
      To exclude tickets with specific tags from your reports, create a standard calculated metric that accounts for tickets with or without those tags, or create a standard calculated attribute to use as a filter.
       
      For detailed instructions, see the article: Reporting with tags.
       
      I hope that helps!
       
      Irene11
      • Irene11
      • Author
      • May 9, 2023

      Thank you so much for the help and the clear instructions @david18! Your solution did exactly what I needed.

        David18
        • David18
        • May 9, 2023

        Glad it helped, Irene! Good luck!

        Terms & ConditionsCookie settingsAccessibility statement