Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started115 News & announcements114 Who's hiring415 Release notes (archive)63 Lesson Comments13 Challenge10
Looker developmentLookML1571 SQL286
Exploring & curating dataExplores495 Dashboards & looks1359
Application developmentEmbedding Looker / Powered by Looker133 Open source projects48 Looker API331
AdministrationUser access & management52 General Looker administration415
Data science & analyticsGot a question?70 Share your best practices16
コミュニティフォーラム (Japanese)ニュースと告知43 ヘルプとサポート11 コラム69
The Kitchen TableTechnical Tips & Tricks1659 Common Account Questions14 Blog Archives3 DCL Mic Drops5

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

1681 Topics

Recently active

Most replies Most views Newest first

Article Custom liquid formatting isn't displaying in visualization

Last Tested: Jan 21, 2019 DCL tip: To display custom liquid formatting, use {{ rendered_value }} instead of {{ value}}{{ value }} The output displays the standard result from querying your database. Used when datatypes don't matter Output of the code below will be only display the raw query data. (...

Technical Tips & Tricks

Article "Variable not found" error in liquid html

Last tested: Jul 3, 2018 One reason you might get this error in liquid is if you use {{ }} and {% %} at the same time, like this:{% if value > {{ search_latency_top_hr.limit_95._value }} %}The appropriate way to do this is this:{% if value > search_latency_top_hr.limit_95._value %}Docs This co...

Technical Tips & Tricks

Article Preserving drill fields when conditional formatting is applied

Last tested: Jan 21, 2019 Tip: Use the <a></a> tag instead of your <p></p> or <div></div> tagWhen applying conditional formatting to the cells of your visualization using the HTML tag, you may lose your drill field functionality if not careful. To solve this use t...

Technical Tips & Tricks

Article Add a total's column to a stacked bar chart

Last tested: Oct 14, 2020 Using Table Calculations, you can add a total column to a stacked bar chart. (Note: If your bar chart is not stacked, you can add a total column by simply checking the row totals box and pivoting on your dimension)METHOD 1: TOTAL COLUMN WITH BREAKDOWNStep 1: Configure your...

Technical Tips & Tricks

Article 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. )?

Last tested: Oct 25, 2019 Simple CaseIn the url of a link parameter, you can omit the instance name and Looker will fill in the instance name with the instance you're on when you click the link. So you can just use /dashboards/123 .User Attribute WorkaroundIf you want something dynamic that isn't ju...

Technical Tips & Tricks

Article Why are my stacked column series not maintaining a constant series order from low to high?

Last tested: Oct 26, 2018 Most likely you have chosen the Series Order option from the main EDIT > Plot menu. When using Stacked or Stacked Percentage plot (either column or bar), you have the choice to use:Default Descending AscendingDefault will maintain the constant series order for each colu...

Technical Tips & Tricks

Article Why aren't all my zipcodes being visualized in the interactive map viz?

Last tested: Jan 21, 2019 There are a couple of possible reasons for this. First, the built-in us_zipcode_tabulation_areas map layer used to visualize zipcode data in the interactive map is built from 2010 census data. It's possible that some of the zipcodes not showing up were created more recentl...

Technical Tips & Tricks

Article Why can I drill even though I don't have the see_drill_overlay permission?

Last tested: May 29, 2019 Within Looker, the see_drill_overlay permission is included in the explore permission, so if a user has the explore permission, they will be able to drill by default.It's the second sentence in the permission list:https://docs.looker.com/admin-options/settings/roles#see_dri...

Technical Tips & Tricks

Article Why can't I "hide no's from visualization" in a table calc?

Last tested: Sep 11, 2019 Double check to see if the Yes and No values have quotes wrapped around them!Note that if(${field_name} > x, "Yes", "No") is not the same as if(${field_name} > x, yes, no). If we include quotes around the yes and no values, Looker will output strings and we'll lose th...

Technical Tips & Tricks

Article What happens when a null is concatenated with a value?

Last tested: Jan 21, 2019 Just like arithmetic operations on a list, a null will make the entire result null. This content is subject to limited support.

Technical Tips & Tricks

Article Is it better to use the running_total measure or to use Table Calculations to perform a running_total?

Last tested: Jan 21, 2019 This can vary on your use case; however, Table Calculations provide more flexibility as they are run after your the Explore page returns results.This point is important to consider when your Explore results table has Pivoted Columns. Pivots will impact the Measure of `type:...

Technical Tips & Tricks

Article How do I hide personal folders for users?

Last tested: March 2021 By default, in an open system, users have access to everyone's personal folder. If you want to hide those from users, you have two options: Enable Closed System and then disable Closed System. Enabling Closed System will remove the "All Users" group from the instance. When yo...

Technical Tips & Tricks

Article Conditional formatting (font size, color) in a table viz

Last tested: March 2021 There are currently options for font size in the table-next visualization.As of 4.10, we have conditional formatting that can be used in the table visualization. As of 5.2, this can be applied on a per-measure basis. This only affects colors, not font size.Size customization...

Technical Tips & Tricks

Article Why is my query crashing my browser or making the page unresponsive?

Last tested: May 2020 This Help Center explains why a query can crash your browser but be fine on the instance and/or database.The rule of thumb is that 30,000 cells will choke most browsers. You could also crash a browser with one cell that has an incredibly large amount of text inside.At some poin...

Technical Tips & Tricks

Article Can I add filters to a Look URL?

Last tested: April 2021 Yes, it looks like this:https://myinstance.dev.looker.com/looks/6384?f[view.dimension_date]=last+1+daysAny additional filters are declared with another &:&f[view.filter_1_dimension]={{ value }}&f[view.filter_2_on_date]=last+60+daysFilters are all you can bring thr...

Technical Tips & Tricks

Article What does a row limit of -1 mean?

Last tested: March 2021 This is the number Looker uses to represent "unlimited results". You might see it in API results or the internal database, but you cannot enter it manually into the UI.For allowed row limits, see https://help.looker.com/hc/en-us/articles/360001285567-What-are-all-the-Row-Lim...

Technical Tips & Tricks

Article Why can't I assign a model set to a Role?

Last tested: June 2020 If the Role has the manage_models permission, then their models cannot be limited. This behavior is explained in the permissions docs:"Each LookML model is mapped to a specific set of database connections on the Manage LookML Projects page. This permission lets the user config...

Technical Tips & Tricks

Article How does an incorrect relationship affect queries?

Last tested: March 2021 The relationship parameter only tells Looker whether or not to use symmetric aggregates. So, the worst case scenario from an incorrect relationship is that Looker does not apply symmetric aggregates when it really needs to. Thus, you can have fanout and potentially incorrect...

Technical Tips & Tricks

Article Why are my only filter options “is on the day/is equal to” and “matches user attribute”?

Last tested: March 2021 If you are using a parameter as your filter, you will only see these two options, since parameters are designed to insert a single value into your code.On a dashboard, this will occur if the "Allow Multiple Values" feature for dashboard filters is off. Try turning it on. Thi...

Technical Tips & Tricks

Article List of visualization options no longer available in Enhanced Visualizations

Last tested: July 2019 The following visualization options are no longer available in Enhanced Visualizations (Looker 6.0): Plot - Series Order (this can also be missing if Stacked or Stacked Percentage is not selected) Plot - Focus Lines on Hover Values - Value Density X - Time Tick Count...

Technical Tips & Tricks

Article How do I get queries to run without symmetric aggregates applied?

Last tested: March 2021 You shouldn't do this. Symmetric aggregates are designed so that measure values are consistent no matter what joins are used in the query, and Looker does not support any solution that generates different measure values depending on what tables are joined.But what about the s...

Technical Tips & Tricks

Article What does the MD5 function do?

Last tested: March 2021 MD5 is just a hash that turns strings into hashes.It's useful for making IDs out of a concatenation of several fields, which makes it valuable for joins. Looker uses it in symmetric aggregates.Example:select md5('Amazon Redshift'); md5 ---------------------------------- f7...

Technical Tips & Tricks

Article When should I use a measure of type string?

Last tested: March 2021 Anytime you have an aggregate that returns a string. A common example is a group_concat or listagg, though you could also concatenate two measures into a single string for aesthetic value.The docs explain this in more detail. This content is subject to limited support. ...

Technical Tips & Tricks

Article Can I apply LookML access to a view file?

Last tested: April 2021 No. In Looker, all permissions are defined at the model level or instance level.Views are included in models, so by defining model-level permissions, you're also defining permissions on the included views. This content is subject to limited support.

Technical Tips & Tricks

Article How to pass a filter condition to a derived table AND keep it in the main query

Last tested: March 2021 The ProblemI need a condition to appear in the WHERE clause of my derived table, but I also need it to appear in the WHERE clause of my main Looker-generated query. So my final query should have the same condition in both places, like so :WITH derived_table AS ( SELECT * FRO...

Technical Tips & Tricks

1
...
64
65
66
67
68

Page 67 / 68

Powered by inSided

Sign up

Already have an account? Login

Social Login

or

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

*

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

© 2021 Looker Data Sciences, Inc.
community@looker.com
Privacy | Terms | Cookies | Community Guidelines