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 

Custom fields

3min



Introduction

You can create new ad hoc custom dimensions and measures in Explore using custom fields. This page discusses creating and using custom fields to enhance your data analysis.



Learning the ins and outs of looker has never been easier with the free and introductory tool from Google Cloud. 

What are Custom fields?

Looker allows you to create and utilize ad hoc fields for richer data analysis. This is done by creating custom measures, dimensions, and table calculations and using custom groupings to narrow down data to match specific conditions.



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.

Filtering with a Custom field



Suppose we retrieve all orders created on the 10th of each month this current year and see the associated order numbers and created date.

Click on Explore --> Orders, expand the Filters section, and click the Custom checkbox in the upper right.



Custom Filter
Custom Filter




When you start typing, Looker prompts you with operators, functions, and field names that you might want to use in your filters business logic. You can also see that when you hover over the function you are typing, Looker will tell what these functions, operators, and field names do.



Custom Filter functions
Custom Filter functions




Type in extract_days(${x_fct_trans_orders.order_created_at_date}) = 10

Click on Visualization and click Columns

On the Explore click Order Number to include it to your report along with any Order Created Date

Click on Order Created Date again and click Filter By field icon



Order Number
Order Number










Order Created Date
Order Created Date




Click Run

You can see all created orders on the 10th of each month for this current year





Orders created every 10th of the month
Orders created every 10th of the month






This document will further describe the functions available

You can also add the custom filters to your custom field

Click Custom Fields and click Add





Add Custom Fields
Add Custom Fields




Select Dimension and paste the function used above extract_days(${x_fct_trans_orders.order_created_at_date}) = 10

Provide the Custom Dimension a Name and click Save



You've just created and saved a custom dimension field!





What are Measure and Dimension fields?

You can use Dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Measures contain numeric, quantitative values that you can measure. Dimensions include qualitative values (names, dates, or geographical data).

A measure is a field that can be aggregated in some way, such as a sum or an average. Think of it as something that can be collected, counted, or combined in some way to return a single value



We saw above an example of a Custom Dimension with retrieving Orders every 10th of the month. An example of a Measure would be if you wanted to know the average count of Product in your customers' cart



Custom Measure
Custom Measure




For more information about Custom fields and Measure Vs Dimension fields please refer to Looker documentation 





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
Looker and Shopify data models
NEXT
How to 'Save and Schedule' reports
Docs powered by archbee 
TABLE OF CONTENTS
Introduction
What are Custom fields?
Filtering with a Custom field
What are Measure and Dimension fields?