Is there a a bubble visualization in Looker?
Knowledge DropLast tested: Sep 6, 2019 As of 5.20, there is a "Size points by field" option for scatter charts...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
Is there a character limit for content in the Admin Content Sidebar?
Knowledge DropLast tested: Apr 29, 2019Yes! 255 for the title and 255 for the body.This content is subject to ...
"Variable not found" error in liquid html
Knowledge DropLast tested: Jul 3, 2018 One reason you might get this error in liquid is if you use {{ }} and {...
Custom liquid formatting isn't displaying in visualization
Knowledge DropLast Tested: Jan 21, 2019DCL tip: To display custom liquid formatting, use {{ rendered_value }} ...
Preserving drill fields when conditional formatting is applied
Knowledge DropLast tested: Jan 21, 2019 Tip: Use the tag instead of your or tagWhen applying conditional form...
Is it possible to make the domain in the url of a `link` parameter dynamic, based on the user's instance environment (i.e. prod, dev, etc. )?
Knowledge DropLast tested: Oct 25, 2019 Simple CaseIn the url of a link parameter, you can omit the instance n...
Why aren't all my zipcodes being visualized in the interactive map viz?
Knowledge DropLast tested: Jan 21, 2019There are a couple of possible reasons for this. First, the built-in us...
Why are my stacked column series not maintaining a constant series order from low to high?
Knowledge DropLast tested: Oct 26, 2018 Most likely you have chosen the Series Order option from the main EDIT...
Why can't I "hide no's from visualization" in a table calc?
Knowledge DropLast tested: Sep 11, 2019 Double check to see if the Yes and No values have quotes wrapped aroun...
Why can I drill even though I don't have the see_drill_overlay permission?
Knowledge DropLast tested: May 29, 2019 Within Looker, the see_drill_overlay permission is included in the exp...
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...
Conditional formatting (font size, color) in a table viz
Knowledge DropLast tested: March 2021There are currently options for font size in the table-next visualization...
Is it better to use the running_total measure or to use Table Calculations to perform a running_total?
Knowledge DropLast tested: Jan 21, 2019 This can vary on your use case; however, Table Calculations provide mo...
Why can't I assign a model set to a Role?
Knowledge DropLast tested: June 2020If the Role has the manage_models permission, then their models cannot be ...
What does a row limit of -1 mean?
Knowledge DropLast tested: March 2021This is the number Looker uses to represent "unlimited results". You migh...
Why is my query crashing my browser or making the page unresponsive?
Knowledge DropLast tested: May 2020This Help Center explains why a query can crash your browser but be fine on...
Can I add filters to a Look URL?
Knowledge DropLast tested: April 2021Yes, it looks like this:https://myinstance.dev.looker.com/looks/6384?f[vi...
How do I get queries to run without symmetric aggregates applied?
Knowledge DropLast tested: March 2021You shouldn't do this. Symmetric aggregates are designed so that measure ...
List of visualization options no longer available in Enhanced Visualizations
Knowledge DropLast tested: July 2019The following visualization options are no longer available in Enhanced Vi...
Why are my only filter options “is on the day/is equal to” and “matches user attribute”?
Knowledge DropLast tested: March 2021If you are using a parameter as your filter, you will only see these two ...
How does an incorrect relationship affect queries?
Knowledge DropLast tested: March 2021The relationship parameter only tells Looker whether or not to use symmet...
When should I use a measure of type string?
Knowledge DropLast tested: March 2021Anytime you have an aggregate that returns a string. A common example is ...
How do you overwrite a default value in a link to a dashboard?
Knowledge DropLast tested: May 2020If you have a default value set for a dashboard filter, then the usual meth...
Can the individual series of a pivoted dimension be split between different axes ?
Knowledge Drop Last tested: March 31, 2021No. Each measure goes on one axis. If you have a measure pivoted, al...
Can I apply LookML access to a view file?
Knowledge DropLast tested: April 2021No. In Looker, all permissions are defined at the model level or instance...
Breaking News: Knowledge Drops are LIVE!
Democratizing information has always been a core tenet of Looker’s values. It’s how we all become better think...
