website logo
Navigate through spaces
⌘K
OVERVIEW
ORDER MANAGEMENT (OMS)
SHIPPING - SETUP
Shipping Methods
Shipping Zones
Shipping Method Setup Examples
TAXES - Setup
Tax Automation with Stripe Tax
Tax Automation with Avalara
CONTENT MANAGEMENT (CMS)
DATA
CUSTOMER LIFETIME REVENUE
Customer Lifetime Revenue Explanation
Customer Lifetime Revenue and Purchase Likelihood
Recency Frequency and Monetary
CLR and RFM Data Table Glossary
RFM and CLR in the Hub
LOOKER
Modifying a Dashboard
Timestamp differences between Looker, OMS and Shopify
How to create custom calculations in Looker
Looker and Shopify data models
Custom fields
How to 'Save and Schedule' reports
Creating Custom Reports or Look
Looks vs Dashboards
Login Looker FAQ
Looker Glossary
SEGMENT EVENT TRACKING
What are event tracking
Adding Tracking
What is the Tracking Plan?
The Chord Tracking Plan
The Shopify Tracking Plan
Event Tracking FAQ
EVENT UPDATES PAGE
Email Subscription Payment Event Update
Product Feed Setup
Getting Segment to Production
Consent Management
Installing in Next.js
Installing in Gatsby
Integrations
👩‍💻Developer Tools
Using Chord with Shopify
Docs powered by archbee 

How to create custom calculations in Looker

2min



Introduction

This article will walk you through how to create custom metrics directly within a Looker view



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.



Create a custom calculation

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.



  1. Explore
    Explore
    

Hit 'Add Calculation' on the right hand side of the 'Data' bar.

Add Calculation
Add Calculation




Create your custom calculation.



Edit Calculation
Edit Calculation




Click Save

You've just created a custom calculation!



if you have any questions or need help, please reach out to us at help@chord.co



Updated 03 Mar 2023
Did this page help you?
Yes
No
PREVIOUS
Timestamp differences between Looker, OMS and Shopify
NEXT
Looker and Shopify data models
Docs powered by archbee 
TABLE OF CONTENTS
Introduction
Create a custom calculation