Why is my type: distance returning Unknown or Inaccessible Field?
Knowledge DropLast tested: Jul 24, 2018 With type: distance, if you're feeding the dimension with location dim...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
My Custom Map Layer is set up correctly, but Measure values are not showing up on my Map. Why?
Knowledge DropLast tested: Aug 28, 2017 A possible reason for this is that the Custom Map Layer property key n...
Using liquid to create a custom date range
Knowledge DropLast tested: Jan 27, 2021 This works if a user would like to be able to select a date, and then ...
Can I remove LookML elements like `case` in an extending view?
Knowledge DropLast tested: Mar 15, 2021No. You can only add new LookML elements in an extending view but you c...
Does Looker have native currency conversion?
Knowledge DropLast tested: Dec 5, 2019 The ProblemI have currency data in my database, for example the cost of...
Selected articles about LookML
Selected articles about LookMLWe have gathered some selected community and help center articles and organised ...
How do you use an alias parameter with a dimension_group?
Knowledge DropLast tested: Aug 6, 2018 You just alias the dimension group itself, not the individual fields. S...
Can I force a user to use a filter but allow them to change which filter they use?
Knowledge DropLast tested: Aug 21, 2018 Yes! You can use the conditionally_filter parameter on your explore, w...
Using multiple values in a single parameter
In the event that you want to do something crazy like this:When you want parameters to be all they can be Para...
My LookML Validator is slow!
Knowledge DropLast tested: Jun 25, 2020TL;DR:The bigger the project is, the longer it takes to validate.Quick ...
No Matching Signature for operator >= for argument types: TYPE, OTHER TYPE
SQL Error Series #1: Type ErrorsPost Context: This content is adapted from our internal SME (Subject Matter Ex...
When extending an explore, can I exclude an existing parameter like `always_filter` or `conditionally_filter` on the new extended explore?
Knowledge DropLast tested: May 6, 2020No, we currently cannot leave out a specific parameter on the extended e...
Formatting large numbers as digit with magnitude (Mil, Bil, etc.)
Knowledge DropLast tested: Jan 21, 2019 In the visualization menu, open the X or Y axis menu and in the field ...
Why do I only sometimes need substitution operators?
Knowledge DropLast tested: Jul 4, 2018 The difference is that ${foo} refers to the value in the field, whereas...
persist_for hierarchy
Knowledge DropLast tested: Jan 16, 2019 persist_for can be applied to PDTs, Models and Explores.There is a sig...
Why do I have duplicate PDTs?
Knowledge DropLast tested: Apr 4, 2020 PDTs can be shared by multiple models. When duplicates show up in the A...
Where can I use ${view_name.SQL_TABLE_NAME}?
Knowledge DropLast tested: April 2021Currently this syntax can be used anywhere that accepts valid SQL, INCLUD...
Advanced LookML - Hub and Spoke modeling
Knowledge DropLast tested: Dec 18, 2019 One of the core benefits of LookML is that it stops you from repeating...
Can I use a dimension in a sql_trigger_value?
Knowledge DropLast tested: Dec 1, 2020Currently no. You can, however, select from ${view.SQL_TABLE_NAME}This c...
Why do I need to specify a type: for my dimension?
Knowledge DropLast tested: Jun 1, 2020 The type: of a dimension impacts two things:1. The filter dropdown opti...
How do I exclude fields from the base explore view file?
Knowledge DropLast tested: Feb 9, 2018 You can do this as expected, just be sure to include the ALL_FIELDS* li...
Can I reuse my LookML code? (Reusing Code with Extends)
Knowledge DropLast tested: Jan 21, 2019 For more information on Extends and how to reuse your LookML code, rev...
Advanced LookML - Cohort and Retention Analysis
Knowledge DropLast tested: Jun 24, 2019 What is a Cohort Analysis?Read this data tutorial here (5 minutes) and...
Can I have models with the same name in different Projects on the same instance?
Knowledge DropLast tested: Sep 9, 2020No, model names must be globally unique according to docs.When Looker ge...
Dynamic Joins - How to use liquid to dynamically adjust sql_on conditions
Knowledge DropLast tested: Oct 22, 2019 Define the different join conditions within liquid if/then control flo...
"Circular reference detected"
Knowledge DropLast tested: Dec 16, 2020 Make sure you're not referencing the LookML field instead of the table...
Where does LookML live? (Git Square)
Knowledge DropLast Tested: May 21, 2019Local Dev Branch These can be found on the Looker server. Inside the `...
How can I extend a model file?
Knowledge DropLast Tested: April 2, 2020You cannot include a model file in another model file, but if you want...
Can I exclude views instead of include them?
Knowledge DropLast tested: March 21, 2021In general, it's best practice to include files rather than exclude f...
How to join the same table twice (self-join)
Knowledge DropsLast Tested: March 22, 2021In a given explore, each join name must be unique. To self-join the ...
