Recent searches
No recent searches
Report on tickets with two specific tags
Answered
Posted Mar 26, 2021
Hello,
I can't figure out how to create a custom calculated attribute to show bugs reported by platforms. E.g. to find all bugs reported for the web app, I need to show tickets with two tags at the same time "bug" and "web".
When I use a condition with only one tag, it works properly (but gives inaccurate results). As soon as I add a second tag condition (the formula is accepted), it breaks and stops showing the category.
This version (with one tag) works (but it also includes tickets that are not bugs):
IF ([Ticket tags]="web") THEN "Web app bugs"
ELIF ([Ticket tags]="mac") THEN "macOS app bugs"
ELIF ([Ticket tags]="win_10") THEN "Windows 10 app bugs"
ELIF ([Ticket tags]="ios") THEN "iOS app bugs"
ELIF ([Ticket tags]="android") THEN "Android app bugs"
ENDIF
When I add a second tag (I tried different ways), nothing works:
IF ([Ticket tags]="web" AND “bug”) THEN "Web app bugs"
ELIF ([Ticket tags]="mac" AND “bug”) THEN "macOS app bugs"
ELIF ([Ticket tags]="win_10" AND “bug”) THEN "Windows 10 app bugs"
ELIF ([Ticket tags]="ios" AND “bug”) THEN "iOS app bugs"
ELIF ([Ticket tags]="android" AND “bug”) THEN "Android app bugs"
ENDIF
neither:
IF (([Ticket tags]="web" AND ([Ticket tags]=“bug”)) THEN "Web app bugs"
ELIF (([Ticket tags]="mac" AND ([Ticket tags]=“bug”)) THEN "macOS app bugs"
ELIF (([Ticket tags]="win_10" AND ([Ticket tags]=“bug”)) THEN "Windows 10 app bugs"
ELIF (([Ticket tags]="ios" AND ([Ticket tags]=“bug”)) THEN "iOS app bugs"
ELIF (([Ticket tags]="android" AND ([Ticket tags]=“bug”)) THEN "Android app bugs"
ENDIF
I would appreciate any help! Thank you!
1
2
2 comments
Stephen Belleau
Hey @...! Take a look at https://support.zendesk.com/hc/en-us/articles/360022183574-Reporting-with-tags#topic_q5d_dms_jkb
So the syntax you're looking for should be something like:
3
Galina Skovorodnikova
@... thank you so much! Not sure how I've missed that article but it's exactly what I need. Thank you!
0