standard calculated attribute | The place for Zendesk users to come together and share
Skip to main content
Lisa33
May 19, 2021
Question

standard calculated attribute

  • May 19, 2021
  • 2 replies
  • 28 views

I'm running into trouble creating the IF statement for creating standard calculated attribute to exclude a specific ticket tag on a report in Explore.  Any help is appreciated. 

    2 replies

    Chandra13
    May 20, 2021

    Hi @Lisa Avellino! Have you tried the formula provided under the "Filtering a specific tag from all metrics on a query" section of this help article? I've included it below as well:

    IF (NOT INCLUDES_ANY([Ticket tags], "Alaska")) THEN "true" ELSE "false" ENDIF

    That should be the formula you'll want to use for creating a standard calculated attribute to exclude a specific tag. From there, you would add this attribute at a filter for your query.

    If you're still having trouble, mind sharing the formula you have so far so that either myself or another community member can help?

     
    Gab12Employee
    Employee
    June 24, 2021

    Hi Lisa,

    Glad that you that you were able to save the metric, but I see that you're seeing errors when using it in your query. We may need to check on this within your instance so I created a separate ticket where we can continue troubleshooting this.

    Thanks!

    Terms & ConditionsAccessibility statement