| Suite | Professional, Enterprise, or Enterprise Plus |
| Support with | Explore Professional or Enterprise |
While Explore's results manipulation can perform basic manipulations to your report results, to unlock the full power of Explore, you can create your own metrics and attributes that report on 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
- Working with data types in Explore formulas
- Troubleshooting errors in Explore formulas
- 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
CJ Johnson
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.
0
Rob Stack
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!
0