Count number of tickets with multiple tags
Hi whoever is able to reply to my question,
I am having trouble by creating an accurate report based on tags.
创建一组属性标签和使用D_Count Ticket metric doesnt help.
Issue is that some Tickets have multiple tags of the Group created and for this reason are counted twice or more.
Example.
Group A = Tag_1 Tag_2 Tag_3
Group B = Tag_4 Tag_5 Tag_6
Ticket contains Tag_3 and Tag_5 counts as 2 tickets for Group A and Group B
Also by separeting the tags they are counted twice for tickets.
How can I count the number of tickets that contains multiple tags but not risking making it count mulitple times?
-
Gerardothis is tough to do directly in Zendesk. If you're comfortable working in spreadsheets, I would import your data with an automation tool like Coefficient (which can refresh the data every hour for you), and then you can setup your logic with some basic spreadsheet formulas like COUNTIFS(Sheet1!A:A,"*Tag_1*"). The asterisks in this formula will read as "contains 'Tag_1' in column A:A.
https://coefficient.io/integrations-google-sheets/zendesk
Let me know if that works!
Pleasesign into leave a comment.
1 Comments