Hello Insights community!
I'm trying to report on the # of tickets which do NOT have any tags in a list.
For example, we have 9 tickets with tag_1, 8 tickets with tag_2, and 20 tickets without either of these tags.
I've tried 2 methods to no avail:
1. Adding the filter Ticket Tag ISN'T tag_1, tag_2
A spot check of tickets shows that this doesn't work - tickets with either tag are included in the report. Ages ago, I talked to GoodData about this and they told me that this is a known limitation of their data model. They pointed me a support article that explained it, but that article no longer exists. :/ (https://support.zendesk.com/entries/219030)
2. Creating a custom metric for # Tickets without tag_1 or tag_2:
SELECT COUNT(Ticket Id,TicketTagId)
WHERE Ticket Status <>
AND Ticket Tag Deleted Flag <>
AND Ticket Tag NOT IN (tag_1, tag_2)
Again, a spot check shows that this doesn't work... Probably because I don't know how to write MAQL.
Can anyone advise? Thanks!
Please sign in to leave a comment.