Splitting Strings into Rows in the Absence of Table-Generating Functions
Looker will not be updating this content, nor guarantees that everything is up-to-date. IntroductionMost SQL d...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
Why are Look/Dashboard IDs null in System Activity History explore?
Knowledge DropLast tested: Apr 17, 2018 Probably because the query isn't tied to a Look or a dashboard, for ex...
Conditional / Dynamic Value Format value_format
Knowledge DropLast tested: Jan 21, 2019 We can't do dynamic formatting using the value_format parameter, but w...
Reverse Running Totals
Looker will not be updating this content, nor guarantees that everything is up-to-date. Starting in Looker 21....
How do I filter out null in a filtered measure?
Knowledge DropLast tested: May 2020Most of these examples can be found in the filter expressions doc.Filter ou...
Use Table Calculations to Get Most Recent Line Item When User Has Duplicate Rows (Non-subquery version)
Knowledge DropLast tested: Mar 19, 2020 If you have line items in a table with duplicate ids, but only wants t...
How do I do a ROW_NUMBER OVER (PARTITION BY ...) with a table calc?
Knowledge DropLast Tested: Jul 1, 2018match(${products.brand},${products.brand})if(${partition}=offset(${parti...
How are files sent to SFTP and S3 buckets named?
Knowledge DropLast tested: May 31, 2019 All file names look like scheduleName_timestamp_hash, where hash is a ...
Can I customize the title of a dashboard tile?
Knowledge DropLast Tested: Mar 10, 2021At the moment, we aren't able to customize the font size, location, and...
Creating a pie chart with over 50 rows using table calcs to create an "Other" bucket
It is sometimes the case that we need to create a pie chart, or any other chart that has row limits, but our r...
Using Liquid Split and Array Filters to Format Lists
Looker will not be updating this content, nor guarantees that everything is up-to-date. This post covers advan...
How do I hide one of my pivot columns?
Knowledge DropLast tested: Mar 16, 2020 If you find yourself here, +1 this feature request: https://feedback.u...
OAuth Error: User not in the authorized domain(s)
Knowledge DropLast tested: Sep 26, 2019 This generally occurs when the user's email domain (eg @looker.com) ha...
What is an Instance Slug?
Knowledge DropLast tested: May 1, 2020 It's an identifier for an instance. Instance slug is the combination of...
Does Looker require access to the scratch schema to write ephemeral derived tables?
Knowledge DropLast tested: Nov 5, 2019 For most dialects a scratch schema is not needed in order to use non-pe...
How to use access filters in derived tables
Knowledge DropLast tested: Oct 31, 2019 QuestionHow do I use access filters inside the SQL of a derived table?...
What HTML tags are allowed? (HTML Sanitization)
Knowledge DropLast tested: March 2021This doc lists all of the allowed HTML tags that can be used in html bloc...
Why do Nulls Still Appear in My Measures After Wrapping the SQL: Parameter in Coalesce()?
Knowledge DropExample a measure of type: average (or Sum/Count/etc) is producing Nulls in an Explore. I want t...
Converting Shapefiles to TopoJSON
Looker will not be updating this content, nor guarantees that everything is up-to-date. Looker uses a format f...
How can I create a new project via the API?
Knowledge DropLast tested: Mar 8, 2018 Use the create_project call on the projects endpoint. https://docs.look...
Selectively highlight data points in visualization using a filter
Knowledge DropLast tested: Sep 6, 2019 The ProblemQuite frequently, a sea of values need to be displayed in a ...
Can I change value label alignment (vertical & horizontal) in stacked bar/column charts?
Knowledge DropLast tested: May 18, 2020 No, that is currently not possible at the moment.If that is something ...
"Field Usage" System Activity explore retention
Is the retention of Field Usage Explore (/explore/system__activity/field_usage) is same as History explore i.e...
Filter a column on multiple values from another column
Knowledge DropLast tested: Sep 7, 2019 Say you want to filter a column by multiple values in a "sub column", i...
How do I make my dashboard timezone listen to the timezone defined in my embed URL?
Knowledge DropLast tested: Nov 2020 Enable User-Specific Timezones in the Admin panel. Add the user_timezone a...
What is the `POST webhooks/projects/[project]/deploy` call I see in logs?
Knowledge DropLast tested: May 29, 2020This is the call Looker makes when creating and pushing a new branchThi...
How Looker does timezones and how to troubleshoot them
Knowledge DropLast tested: Feb 1, 2021 Timezones, yikes!You may need to troubleshoot timezones to answer quest...
How can I use an apostrophe in a user attribute value?
Knowledge DropLast Tested: Jan 21, 2019Just put a \ before the apostrophe!ex. Default value: O\'DonnellThis co...
`Comparison method violates its general contract!` error when running a query.
Knowledge DropLast tested: Oct 6, 2020 This is a pretty weird error that's popped up a couple times. This usua...
SQL Pattern: How can I count the number of comma separated values in a string?
Knowledge DropLast tested: Aug 16, 2017 This might not be a common request, but the method to do so is below:S...
