How do I find an attribute value to use in an Explore formula?

Question

How do I find an attribute value to use in an Explore formula?

Answer

Most values for attributes can be found within the attribute itself. Within a report, add an attribute in either the Columns or Rows panel, and then click the attribute you just added. You'll see the list of possible values for that attribute. 

The example below uses the attribute Ticket group. 

Suppose that you wanted to write an Explore formula that looks for all tickets in the ticket group called Trigger Testing. To specify this condition, you would write the formula like this:

[Ticket group]="Trigger Testing"

If you don't match the exact attribute value (the value in quotation marks in the formula), there won't be any results. For example, the formula below wouldn't return any results because "Trigger Testing" isn't capitalized like it is within the attribute in the screenshot above:

[Ticket group]="Trigger testing"

You can also use various API endpoints to find your values. For ticket groups, use the List Groups endpoint. For ticket field values, use the List Ticket Fields endpoint.

For more information on Explore formulas, see the articles:

• Writing Explore formulas
• Formula writing resources