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: