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:
6 Comments
Hello,
How can I use my custom metrics from Insights in Explore. I have a lot of metrics I would like to carry over.
Kind Regards,
Chris
Hey Chris,
Custom metrics will need to be created from scratch in Explore.
I recommend taking a look at some of these useful articles if you're unsure where to start:
I hope this helps point you in the right direction!
Hello Brett,
It would be much easier if Explore kept the MAQL logic instead of the the new logic. It seems weird that I will have to switch to a totally different program and language to get the results that I already have.
Lg
Chris
Hi Chris,
I totally understand where you're coming from here and I do wish I was able to provide an alternative solution for you. On the plus side, since Explore is our product owned by us, we're always taking feedback and making improvements wherever we can :)
Additionally, if you do run into issues creating a metric, our Customer Advocacy team is happy to take a look and offer up some guidance.
Thanks for taking the time to share this with us!
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.