Looker specific reserved words
Knowledge DropLast tested: May 27, 2020Scenario:We run the LookML validator and see a this error:a dimension/m...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
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...
Query execution failed: - FULL OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join
Knowledge DropLast tested: Aug 28, 2020 We see this happen in Standard SQL (BigQuery uses Standard SQL as the ...
Use dimension type: duration to create a filter denominator
Knowledge DropLast tested: Nov 29, 2018 If we are looking for a way to take the value of a date filter and use...
Does extends override a parameter if the same parameter is defined in both the original and extending version?
Knowledge DropLast tested: Sep 13, 2018 If a LookML object is explicitly defined in both places, then the obje...
Measure of Type: List Linking & HTML
Knowledge DropLast tested: Jun 8, 2020 We cannot currently turn off drill-able links currently when using type...
500 Error on Add To Project
Knowledge DropLast tested: Apr 2, 2020 Problem: Receiving the error: "Uh Oh! Something went wrong. 500" when s...
Why are my explore filters not getting added when I drill down on a measure?
Knowledge DropLast tested: Sep 15, 2019 It is most likely because the measure may have filter defined, i.e it ...
Move the custom drill link to the end of the row.
Knowledge DropLast tested: Feb 3, 2021 This is a great article to show how to do custom drills on a dimension ...
How are relative URLs in the link/html parameter handled? (url = "/explore...", etc.)
Knowledge DropLast tested: Aug 23, 2019 To understand how relative URLs in the link/html parameter are handled...
What characters are accepted in LookML field names?
Knowledge DropLast tested: Jun 19, 2018 TLDR: Only alphanumeric characters and underscores.For certain charact...
Adding a dimension to the explore shows "No Results?" What is happening?
Knowledge DropLast tested: Jul 12, 2017 One potential reason is that you are attempting to filter on a Measure...
Can we define a view: parameter within a Model file? An explore: within a View file?
Knowledge DropLast tested: Jun 28, 2021 This is technically possible, but we recommend against it, mainly for ...
Model Names in the Same Instance
Knowledge DropLast tested: Aug 12, 2020 In the same instance, you can't have two models with the same name, ev...
why can't looker read my topojson?
Knowledge DropLast tested: Mar 1, 2018 Quick answer: Upload your topojson file to a gist and put that link int...
Jira/Fivetran Custom Permissions
Knowledge DropLast tested: Nov 27, 2019 Jira has multiple ways in which you can provision users access to see ...
Troubleshooting Enabling Folders
Knowledge DropLast tested: Nov 27, 2019 If you want to enable folders for your Projects and have a large numbe...
Can I use a '_' in my folder name?
Knowledge DropLast tested: Aug 27, 2020 You most certainly can. There is a possibility you will see this error...
Filtering on Last Business day of Month
Knowledge DropLast tested: Feb 2, 2021 dimension: returned_last_business_day {type: yesnosql: CASE WHEN EXTRAC...
${TABLE} is not allowed in the 'X' property.
Knowledge DropLast tested: Aug 29, 2019 If you get an e-mail with a schedule error and it says ${TABLE} is not...
How to filter on the last day with available data
Knowledge DropLast tested: Jun 5, 2020 Create a yesno dimension like this:dimension: latest_date { type: yesno...
Does the description fields parameter have a character limit?
Knowledge DropLast tested: Apr 30, 2020 Probably but not that we know of - we tested this parameter with 2,000...
Dashboard filter for ${field1} = ${field2}
Knowledge DropLast tested: Aug 17, 2020 If you don't mind editing the model then here is a solution where sett...
Which order do I write my join in sql_on?
Knowledge Drop Last tested: Sep 2020It doesn't matter. According to docs, you can write the join in any order....
Error "Could not find a view named x" when extending a view
Knowledge Drop Last tested: April 2020When extending a view, remember to include the view you're extending.inc...
How to preserve whitespace in string fields
Knowledge DropLast tested: Sep 3, 2020 The ProblemBy default, Looker does not preserve whitespace in string fi...
How do I update LookML via the API?
Knowledge DropLast tested: June 2021This is currently not possible. The lookml-model endpoint does have "explo...
Can I custom sort the explores in the Explore drop-down menu? It defaults to alphabetical.
Knowledge DropLast tested: Sep 21, 2020 No, you may not custom sort the explores. They will be sorted alphabet...
-
Erin_DocsStaff
-
sam8Staff
-
Dr__StrangeloveStaff
-
corgi-lookerStaff
-
chrissieaStaff
-
LookerExpertsStaff
-
veronica_philliStaff
-
gdemontalivetStaff
-
Emma_DocsStaff
-
kendocsStaff
