Downloaded data file contains: Error: Could not sort by calculated field 'total_bla'. Limit reached
Hi, I’m trying to download data for a dashboard and am getting an empty file containing: Error: Could not sort...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Exclude Table Calculations For Null Columns
Created a calculated column for WoW comparisons. Is there a way to exclude instances where all values are null...
Whitespace in Looker
What is whitespace? Whitespace is a character that will occupy space on a page but does not correspond to a vi...
Localizing View and Field Names in Looker
In LookML, you can use aliasing parameters to make data exploration in Looker a much more user-friendly experi...
Date filter up to current point in time
One of the first things I do when I use new BI tool is to come up with sets of dashboards that compare the fol...
Comparing Different Rows Using Table Calcs
Hello fellow Lookers, I spoke with a customer the other day who wanted to compare where their web traffic was ...
Using Merged Results to Do Period Comparisons
Comparing results between time periods can often seem daunting at first glance. Many people fall down the rabb...
Secondary axis creation?
Hi all, I found a very old thread on secondary axis creation but the directions no longer apply or work. I wou...
Prevent Multiple Results in rows
I have a dataset in which I need to calculate the monthly average using the daily counts. So I need to include...
Overriding Look Filters in the Explore Section With Dashboard Global Filters
When creating a dashboard it is important to understand how dashboard global filters override filters that you...
Dynamically set default dashboard filter value?
Hi, What’s the best way to set default, initial value for a dashboard filter in embedded mode? Regular dashboa...
Custom visualizations: css, common code, hovers, & modifying existing visualizations
I’m just diving in to the world of custom visualizations. A few questions: Is it possible to link to css files...
Duplicate rows in pivoted table
We set up an Explore with two dimension (one as rows, one as columns/pivot) and one measure. When the output i...
How to pivot or group by a measure?
Hi, I have a look which, at a basic level, is 1 dimension (user ID) and 1 measure (number of products used). I...
How to add image from my location in the dashboard
How to add image from my location in the dashboard
Hierarchical Drilling and Drill Menus (3.40+)
As of Looker 3.40, we have introduced dimension drilling and drill menus. Drill menus allow for more data expl...
Looker Actions - Digital Ocean Stop Droplet
Looker Actions - Digital Ocean Stop Droplet Looker is launching a Digital Ocean Stop Droplet action, allowing ...
Looker Actions - Twilio Send Data
Looker Actions - Twilio Send Data Looker is launching a Twilio action, allowing customers to send data to a ph...
Looker Actions - Sendgrid
Looker Actions - Sendgrid Looker is launching a Sendgrid action, allowing customers to send data to an email t...
Looker Actions - Zapier
Looker Actions - Zapier Looker is launching a Zapier action, allowing customers to send data to a Zapier workf...
Looker Actions - Digital Ocean Storage
Looker Actions - Digital Ocean Storage Looker is launching a Digital Ocean Storage action, allowing customers ...
Looker Actions - AWS EC2 Stop Instance
Looker Actions - AWS EC2 Stop Instance Looker is launching an AWS EC2 Stop Instance action, allowing customers...
Creating a percent of total across rows with table calculations
Table calculations enable you to create calculations that operate on the table data returned by a SQL query. T...
RETIRED: Filtering in Visualizations using Table Calculations (3.28+)
The content of this article has been moved to Looker Docs here.
Building XmR charts (Shewhart's control charts)
Hi all, I’d like to build XmR charts using Looker, but have not yet succeeded in doing this. I’ve some time-se...
Creating Looker Explores Your Users Will Love
Data is powerful, but can be overwhelming. Especially if you don’t have a background in databases and/or analy...
Now() Table Calculation Function Has Better Timezone Handling (3.48+)
As of 3.48 the now() table calculation will evaluate in the user or query timezone, falling back to the applic...
