Filter on this month but also see previous month's data
Knowledge DropLast tested: May 2020The ProblemYou want to give your users a single date selector, where they c...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
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...
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...
How do I render a local image in Looker?
Knowledge DropLast tested: March 2021Looker expects a public URL for your image. So make sure that wherever yo...
"Internal Server Error" when saving
Knowledge DropLast tested: Jun 23, 2020Please add possible causes as you come across them in the comments!Chec...
Window Functions in Looker
Knowledge DropLast tested: April 2021 How do I use window functions in Looker?Window functions are a very powe...
Max or Min Date Measure Showing Nulls
Knowledge DropLast Tested: March 21, 2021Why is this happening?Looker's min and max types only allows for nume...
Can you auto-generate a model file in an existing project?
Knowledge DropLast tested: May 2020No.When you first make a project, you are prompted to generate LookML for i...
Why is my measure of type:count being made into a COUNT DISTINCT in the SQL?
Knowledge DropLast tested: May 2020A count measure usually creates a COUNT(*) in the SQL. However, if joins ar...
Should I hide or delete unnecessary LookML fields?
Knowledge DropLast tested: Aug 6, 2020 The ProblemI have some LookML fields that I'm not using. They are curre...
Snowflake examples: WTD, MTD, QTD, YTD analysis structure
Knowledge DropLast tested: Jun 30, 2020 Check out Methods for period over period (PoP) analysis in Looker for ...
More than three conditional/dynamic value formats. INCLUDING negative numbers
Those sweet sweet Bs Ms and KsHuge shoutout goes to @Hugo_Selbie who came up with this formula. dimension: val...
How do I apply one filter to multiple fields?
The Use Case: Say you want to have a single filter apply to two separate fields (fields A and B). The end goal...
How do you reference a yesno dimension field value?
Knowledge DropLast tested: March 2021Looker’s “yesno” dimensions return boolean values (TRUE or FALSE) rather ...
How do I filter results in my visualization, without filtering out rows in the data tab?
The Problem:I have a use case where I need to filter out rows in my visualization, but need all the rows to re...
How to sort by rolling month
Knowledge DropLast tested: Oct 4, 2019 To sort their data by current month for ex: October 2019 thru November ...
Error: Unknown view. View does not exist in model. Check for typos or missing include statements.
Knowledge DropLast tested: March 2021ProblemYou receive a LookML error that complains about an unknown view. T...
How to apply access_filters to views
Knowledge DropLast tested: May 6, 2020The ProblemI have an access_filter for one of my explores. But I'd like ...
month_x timeframe
Knowledge DropLast tested: Feb 3, 2019 This came from a custom month_18 (group by every 1.5 years) timeframe i...
How do I format a date so that it respects timezones AND can be downloaded as a CSV?
Knowledge DropLast tested: Jan 21, 2019 It's convenient to format a date with liquid, but HTML formatting is n...
How do I make a primary key for my dimension group (timestamp, date)?
Knowledge DropLast tested: May 11, 2020 Since a dimension group is a collection of dimensions, you can't make ...
General Code & LookML Troubleshooting Steps
Knowledge DropLast tested: Mar 29, 2019 ProblemMy code is throwing an error, and I don't know what part of the...
How to write a correlated subquery in a measure
Knowledge DropLast tested: Dec 9, 2019 The ProblemI want to write a correlated subquery, but I'd like to do it...
Can I control the row limit for drill-down overlays?
Knowledge DropLast tested: Jun 7, 2017 Yeah, there is an awesome way to get this working in the drill modal: m...
Creating Primary Key for repeated nested field in BQ
Knowledge DropLast tested: Apr 3, 2020 If you run into a BQ challenge where no primary key was present in any ...
Setting up an access_filter that applies to only specific users
Knowledge DropLast tested: Mar 27, 2019 Every user who accesses an Explore that has an access_filter must have...
Looker specific reserved words
Knowledge DropLast tested: May 27, 2020Scenario:We run the LookML validator and see a this error:a dimension/m...
Can I reference a dimension_group in a 'fields' or 'set' parameter
Knowledge DropLast tested: Apr 11, 2019In order to reference the full dimension_group, we must list out each t...
Why do I need to specify the type of my dimension?
Knowledge DropLast tested: Aug 16, 2018 Chat tip: Inputting type parameter of dimension isn't required but wil...
Who ran the lookML validator (logs)
Knowledge DropLast tested: Oct 7, 2020 Get the project name Search for (replace MY_PROJECT_NAME with your proj...
