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

4 Comments

  • Ryan Mumby
    Comment actions Permalink

    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.

    0
  • Gab
    Comment actions Permalink

    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!

    0
  • Maddi
    Comment actions Permalink

    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?

    0
  • Ryan Mumby
    Comment actions Permalink

    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. 

    0

Please sign in to leave a comment.

Powered by Zendesk