Custom Dimensions - Introduction

josephmckeownjosephmckeown Moderator, Lightspeed Staff Posts: 80 moderator
edited May 2019 in Reporting & Analytics

The Custom Dimensions tool is a feature in Lightspeed Analytics that gives you the ability to define your own Dimensions and your own naming conventions following data that Lightspeed is sending to Analytics.

The language of Custom Dimensions is Looker Syntax, which you can learn more about either in the Looker Syntax reference guide, or in our Calculations Home.

There are a few differences between how Custom Dimensions and Table Calculations work though. Here are some of the key differences

1) Table Calculations require their relative data to be on your table. Custom Dimensions can read information that is not on your data table.

Let's say I want to gather my top-level categories into Cohorts of multiple Top-Level Categories. I could use the Same formula to create the Cohorts, either in a Table Calculation, or a Custom Dimension

The visible results are the same...

But if I remove the original Top-Level Category from the table, what happens?

My Table Calculation won't work any more, but my Custom Dimension does.

2) We can Pivot and Filter on Custom Dimensions

Table Calculations can only be defined one column at a time. Our Custom Dimensions can pivot so that the data follows the rules that we set automatically...

Also, we can use our Custom Dimensions as a Filter...

3) Custom Dimension Data can exceed the displayed row limits, and continue to sort properly.

When we have more data than the available rows can display, we will see the yellow "Row limit reached" bar...

Now if we try to sort using Table Calculations we will get an error...

...but if sorting by Custom Dimensions will continue to work as any other Dimension!

4) Custom Dimensions can't look at Measures, Table Calculations, or Position on the table.

The formula builder will only see Dimension-specific data. If we look for Sales Totals in the "Edit Custom Dimension" tool... won't even know where to look. So some functions may still require you to use Table Calculations.

But we'll find some neat ways to use Custom Dimensions to make more precise reports.

Calculations Home

Joseph McKeown
Lightspeed Analytics and reporting consultant
Lightspeed HQ
Sign In or Register to comment.