Creating custom metrics in Explore to pull tickets with 2+ tags | Community
Skip to main content

Creating custom metrics in Explore to pull tickets with 2+ tags

  • July 24, 2019
  • 5 replies
  • 0 views
M

Most of our valuable data requires metrics that have more than 1 tag. 

Is there a way to create a metric to pull # of tickets with more than 1 tag?  For example, # of tickets solved with tags 'canada' and 'processed'.

This is possible in Insights and we would need this in Explore in order to pull valuable data. 

 

 

    This topic has been closed for replies.

    5 replies

    R
    • Ryan16
    • July 26, 2019

    Hey Maddi,


    From the query you're building select Calculations (calculator on the right), then choose Standard Calculated Metric.

    Try this formula

    IF([tag]="canada" AND [tag]="processed")
    THEN [Ticket ID]
    ENDIF

    Drill into your data and do some spot checking by looking up a few randomly selected Ticket ID's to make sure it's grabbing tickets with the data you expect, but this should do the trick.

    Zendesk recently changed how they call out the the "Tags" attribute in their formulas though so I'm not 100% certain. They've moved from a model that called out Ticket, Org, User etc tags separately to 1 single "Tag" attribute, which is why I'm suggesting the checking to make sure its operating correctly.

    G
    • Gab12
    • July 29, 2019

    Hi Maddi,

    You can copy the formula that Ryan provided above. Thank you Ryan for this! :-)

    This should give you the data that you need on your query.

    Cheers!

    M
    • Maddi
    • Author
    • July 29, 2019

    Copied the formula above and changed it to fit our tags (thanks Ryan!), but am getting this error:

     

    When I go into chart configuration, I get this: 

    Any insight on how to get the above formula working?

    From what I've read, Explore can't pull data using the 'AND' function.  Is this still the case, explaining why I can't pull data?  Is there any other way for us to pull data using metrics with 2+ tags?

    R
    • Ryan16
    • July 29, 2019

    Hey Maddi - I'm able to save the above just fine in my instance. I would say double check your syntax or repost a screenshot of the actual formula here for us to have a look and verify there are no errors in the formula, and if that's not working then you might have to contact support and report a bug. 

    R
    • Riya
    • November 10, 2020

    I was coming across that error as well. It looks like `[tag]` needs to be replaced with `[Ticket tags]`

    I've found this other comment to be more helpful: https://support.zendesk.com/hc/articles/360022186094/comments/360001857174

    Quoted (and modified) here:

    IF (([Ticket tags]="your_tag_name") AND ([Ticket tags]="your_tag_name_second") )THEN [Ticket ID] ENDIF

    replace your_tag_name and your_tag_name_second with the tags you want to search for.

    Terms & ConditionsCookie settingsAccessibility statement