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?