Which TLS version and ciphers are supported for Looker hosted customers?
Knowledge DropLast tested: Apr 8, 2020 In order to connect to a Looker-hosted instance, the your web browser o...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
How to kill long running queries through the API
Knowledge DropLast tested: Apr 8, 2020 To kill a long running query through the API, you can first get a list ...
Filter On Current Week Of Year
Knowledge DropLast tested: Jan 21, 2019 Use a custom filter:${week_of_year_dimension} = ceiling(diff_days(date...
Dev Mode PDTs
Knowledge DropLast tested: Sep 9, 2019A PDT that has been created/modified in a user's dev mode has the follow...
SSO Embed locale/ localisation
Knowledge DropLast tested: Dec 10, 2020 You can set an embed users locale by adding it to the user_atttributes...
How do I Referencing a Dimension from Another View in Drill Fields?
Knowledge DropLast Tested: May 13, 2020You can use the view_name.field_name syntax to reference a field from a...
How to extract names from email address in table calc
Knowledge DropLast tested: May 7, 2020 The ProblemUsers will sometimes want to get a substring of their dimens...
PDT trigger value at a specific time and day of week, once a week
Knowledge DropLast Tested: Mar 22, 2021 This trigger changes weekly at 6 am on Monday:MSSQL: SELECT FLOOR((DAT...
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...
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 ...
