While Explore's results manipulation can perform basic manipulations to your query results, to unlock the full power of Explore, you can create your own metrics and attributes that query and present your business data just how you want it.
In order to create custom metrics and attributes, you'll need to become familiar with writing formulas that read, and perform operations on your data. For example:
- Measure the difference between two dates
- Construct conditional statements, like "Show me only tickets where the ticket channel is email"
- Perform simple and complex mathematical calculations
- Perform complex text search and replace operations using regular expressions
The following articles will help you learn more about how to write formulas:
- Writing Explore formulas
- Explore functions reference
- Using the IF THEN ELSE function
- Adding multiple conditional expressions with SWITCH
If you're looking for information about the metrics and attributes you can use when you write Explore formulas, see the following articles:
2 Comments
It would be awesome if this page linked to the resource that defines the built in attributes. I just can't find it anywhere on the site anymore, and it's pretty vital for writing formulas.
Hi CJ Johnson, thanks for the feedback. That's a great idea and I've just added it to the article. I hope this helps. Thanks again!
Please sign in to leave a comment.