standard calculated attribute | Community
Skip to main content

standard calculated attribute

  • May 19, 2021
  • 2 replies
  • 0 views
L

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

    C
    • 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?

     
    G
    • Gab12
    • 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 & ConditionsCookie settingsAccessibility statement