Writing Explore formulas

Have more questions? Submit a request

11 Comments

  • Quentin
    Comment actions Permalink

    How do you use Attribute values?

    For example I want to filter a certain value of an attribute (filter out deleted tickets), in GoodData it looked like this: "Ticket Status <> Deleted"

    0
  • Molly
    Comment actions Permalink

    Hey Quentin!

    Deleted tickets are already excluded from the Support Tickets dataset so any metrics you make there do not need any additional modifications. If you use the Ticket Updates dataset, deletion events will be included there.

    0
  • Quentin
    Comment actions Permalink

    Thanks Molly for the explanation.

    But how do you filter by status for example? If I want to see only open tickets in my metric? Something like [Ticket Status]=Open?

     

    0
  • Rob Stack
    Comment actions Permalink

    Hi Quentin, there are two options.

    1. Without a custom metric. Add the Ticket Status attribute to a panel and then click it. You can include, or exclude the values you want. In your case, you’d select only Open.

    2. Use a custom attribute. You are correct, in your suggestion, but you do need quotes, for example:

    [Ticket Status]="Open"

     

    Hope this helps!

    1
  • Quentin
    Comment actions Permalink

    Perfect Rob!

    Thanks for the tip :)

    0
  • Paul Stolz
    Comment actions Permalink

    How can I create a formula to show the end-user phone number in a Query? Currently, there is a row value for End-user email, but not for end-user phone number. 

    0
  • Graeme Carmichael
    Comment actions Permalink

    Paul

    Unfortunately the user's phone number is not part of the dataset so you cannot report on it using Explore.

    In Support, you would have to copy the phone number into a custom user field and then use the custom field in Explore.

    0
  • Gef Faelden
    Comment actions Permalink

    Can you add a comment in your calculated field/metric?

    0
  • Devan
    Comment actions Permalink

    Hello Gef Faelden,

    My recommendation would be to use a datatip to accomplish this. I've shared a link below to an article that explains how to implement these and its range of uses.

    Working with datatips

    Best regards. 

    0
  • CS Analyst
    Comment actions Permalink

    Hi,

    Comparing to the Insights, how to express metric formula with this logic in Explore?

    I can find the Ticket Tags in Fields but I can't find the tag "category_id_175" that i need.

    Regards.

    0
  • Madison Davis
    Comment actions Permalink

    Hi there! I think you'll want to look at Reporting on ticket tags in Explore for help writing this metric. 

    Specifically, you could write a standard calculated metric with the following formula:

    IF ([Ticket tags]="category_id_175") THEN [Ticket ID] ENDIF

    Then filter your query for date ticket created. Unlike in Insights, you can just type the entire formula rather than selecting elements from a menu. Additionally, you can report on this ticket tag without a custom metric, as outlined in the first article on reporting on ticket tags. 

    0

Please sign in to leave a comment.

Powered by Zendesk