Writing Explore formulas

Have more questions? Submit a request


  • Quentin

    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"

  • Molly VS

    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.

  • Quentin

    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?


  • Rob Stack

    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!

  • Quentin

    Perfect Rob!

    Thanks for the tip :)

  • Celia Johnson

    This article is linked to from here: https://explore.zendesk.com/hc/en-us/articles/235948948-Creating-standard-calculated-metrics-and-attributes as a reference for all available functions, but there's no list here of those functions? 

  • Dan Kondzela

    Hi @Celia Johnson,

    It seems you're correct. I assume you are referring to the link called Formula Writing Resources? I selected that and see what you mean, there is no explicit list. After following the link to Formula Writing Resources I noticed the same, no list of functions. 

    To assist in clarity of communication I have flagged these articles to check the hierarchy is set up as expected and to clarify where needed. For the time being I do think the formula writing resources will be helpful.

    Thanks for raising this!


Please sign in to leave a comment.

Powered by Zendesk