Chord Commerce Data Platform
Dashboards and Looks
Creating Custom Calculations
2min
Updated 19 Dec 2023
Did this page help you?
This article will walk you through how to create custom metrics directly within an explore dataset.
The default timezone in Looker for OMS timestamps is UTC, whereas the OMS UI displays EST.
Within Looker, we've added additional timezone options for some of our timestamps but not for Order Approved Date. Custom time zones can be created with a custom field and can be submitted as a feature request.
While Chord's data engineers have built plenty of out-of-the-box metrics for you to explore, we understand that you may find yourself needing to create custom calculations.
Navigate to your Looker account and choose the 'Explore' page with the data points that you are looking to include in your custom metric.
On the right-hand panel, select the measures that will be part of your calculation. For example, Abandoned Cart = # of Customers That Added Product to Cart- # of Customers who Check out, both of these measures will need to be selected in order to create a calculation. You will see the measures pop up in the 'Data' field at the bottom of the screen.
Hit 'Add Calculation' on the right hand side of the 'Data' bar.
Create your custom calculation.
Click Save
You've just created a custom calculation!
if you have any questions or need help, please reach out to us at [email protected]