Advanced LookML - Intro Aggregate Awareness
Knowledge DropLast tested: Jun 24, 2019 This is a useful method if you have summary tables defined in your ETL...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
Why does the exact same SQL run fine in SQL Runner but errors in Explore?
Knowledge DropLast Tested: Jan 21, 2019In some instances, the same exact SQL will run perfectly fine in SQL Ru...
What is a fanout?
Knowledge DropLast Updated: Jan 21, 2019A "fanout" happens when you join two tables and a single value gets du...
YTD, MTD Comparison
Knowledge DropLast Tested: Sep 21, 2018This assumes date dimensions already exist in view.Essentially, you'll ...
SQL Error: "X is not a valid group by expression"
Knowledge DropLast tested: March 2021This SQL error means that that database is trying to group on something t...
Why is my percent or average measure showing zero (or rounding to an integer) aka where are my decimals?
Knowledge DropLast tested: May 1, 2020Here's a Help Center article to explain this question.ExplanationIf you ...
Why is Looker not writing the Join condition in the generated sql? (sql_on)
Knowledge DropLast tested: Jan 21, 2019 In all likelihood the LookML model syntax is using sql: INSTEAD of sql...
What happens when a null is concatenated with a value?
Knowledge DropLast tested: Jan 21, 2019 Just like arithmetic operations on a list, a null will make the entire...
-
sam8Staff
-
Dr__StrangeloveStaff
-
corgi-lookerStaff
-
chrissieaStaff
-
LookerExpertsStaff
-
veronica_philliStaff
-
Erin_DocsStaff
-
Emma_DocsStaff
-
kendocsStaff
