Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started113 News & announcements112 Who's hiring414 Release notes (archive)63 Lesson Comments12 Challenge10
Looker developmentLookML1561 SQL284
Exploring & curating dataExplores490 Dashboards & looks1355
Application developmentEmbedding Looker / Powered by Looker132 Open source projects48 Looker API331
AdministrationUser access & management51 General Looker administration414
Data science & analyticsGot a question?69 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

Newest first

Recently active Most replies Most views

Article Do log levels persist through a restart?

Last Tested: May 20, 2020 Starting in Looker 7.6, log severity levels are persisted through Looker restarts. Prior to 7.6, an instance restart would reset the log levels to the default values. This content is subject to limited support.

Technical Tips & Tricks

Article What's the difference between sql_where and sql_always_where?

Last Tested: Jul 3, 2018 sql_always_where is at the Explore level and will always appear in the where clause. sql_where is set at the join level and will only appear in the where clause if the join is made.Reference our documentation: https://docs.looker.com/reference/explore-params/sql_where This c...

Technical Tips & Tricks

Article Why isn't my Conditional Formatting rule applying to my Percent values in table visuals/table calculations?

Last Tested: Jan 21, 2019 This can happen if you are applying a Default Format option or a value_format OR value_format_name on your Table Calculation or LookML fields, respectively. For example:Table Calculation Expression${products.count}/sum(${products.count})This will typically produce a value o...

Technical Tips & Tricks

Article How to search for a newline symbol (\n) in LookML

Last Tested: Mar 9, 2018 As LookML treats these as single spaces, you can search for empty lines either in terminal or any text editor using this:grep '^$' filegrep '^[[:space:]]*$' file # include white spaces There's also a Chrome extension for Regex search.For some insight from Stack Overflow, see...

Technical Tips & Tricks

Article Can you remove a front end sort (^, v) from an explore or look column?

Last Tested: Jan 21, 2019 No, once you click the column header you'll only then be able to toggle between DESC and ASC (v, ^ ). Only way to 'remove' the sort is to start over. This content is subject to limited support.

Technical Tips & Tricks

Article YTD, MTD Comparison

Last Tested: Sep 21, 2018 This assumes date dimensions already exist in view.Essentially, you'll want to create a yesno dimension that returns YES if date is before todayMTD Comparison (MySQL):dimension: is_before_mtd {type: yesnosql: EXTRACT(Month from ${date_date}) < EXTRACT(Month from CURRENT_...

Technical Tips & Tricks

Article Why Would you use Google OAuth with Looker?

Last Tested: Jun 12, 2019 It's User-Friendly:Google OAuth is a single-sign-on (SSO) authentication method - this means the user has to sign in only once, and then they have access to all the applications on which G OAuth is set up, automatically. They don't need to be added to any external platform,...

Technical Tips & Tricks

Article Can I use Table Calcs to find the total number of rows in my result set? (max)

Last Tested: Jan 21, 2019 Yes, you can use the formula below to see the max number of rows in your result set.max(row()) This content is subject to limited support.

Technical Tips & Tricks

Article If I have multiple instances (prod, staging), are user accounts with the same email tied across instances?

Last Tested: Sep 6, 2019 No! Even if using the same email address, a user account on Instance A is not the same as the user account on Instance B. Even when a user has multiple instances (i.e. company.looker.com, company-staging.looker.com, companyonprem.looker.com)Same goes for passwords. User coul...

Technical Tips & Tricks

Article Is it expected that Looker will round very large numbers? (lose precision)

Last Tested: Jul 3, 2018 Yes, the limitation will happen at around 16-17 digits and it will round the additional integers into "0"s. For example:5820847388981125942 becomes5820847388981126000Overall it is a precision limit of javascript.WorkaroundsUse {{ rendered_value }}dimension: id {primary_key:...

Technical Tips & Tricks

Article Git Lock Errors

Last tested: March 2021 If you get an error with a git operation that mentions a lock, there is probably a lock file.These files are usually temporary and will go away if you wait a sec and try the operation again.If you have command line access to the git repository, you can run git gc to figure o...

Technical Tips & Tricks

Article How do I visualize a dimension as a measure?

Last tested: March 2021 You may be wondering how to plot a dimension on the y-axis of a visualization.Quick SolutionThe quick way to do this is with a table calc involving an existing measure.${dimension} + ( ${measure} * 0)A similar approach can be taken with this table calc for a String dimensioni...

Technical Tips & Tricks

Article How do I fix REJECTED_NONFASTFORWARD errors?

Last verified: March 2021 This can happen when your branch on the remote is ahead of your local branch and you go to deploy.Solution 1: Shift click the git drop down and hit "pull remote changes".Note that this will overwrite any local changes (anything you've saved without committing) since your la...

Technical Tips & Tricks

Article Will "Clear Cache and Refresh" affect filter suggestions?

Last tested: March 2021 No. The suggestions have their own cache that cannot be manually cleared from the explore page. If you need to clear cache for suggestions, here are some other options: If the explore is cached using a datagroup with a sql_trigger, you can manually reset the cache for the ent...

Technical Tips & Tricks

Article Can I drill down on a drill down?

Last tested: March 2021 Yep! As long as the fields have drill_fields defined, you can continue drilling on the drill modal to infinity and beyond (the drill modal will reload upon each consecutive drill). This content is subject to limited support.

Technical Tips & Tricks

Article What HTML tags are allowed? (HTML Sanitization)

Last tested: March 2021 This doc lists all of the allowed HTML tags that can be used in html blocks in Looker. This content is subject to limited support.

Technical Tips & Tricks

Article Can I remove sorts (order by) from the SQL?

Last tested: June 2020 This is not an option by default in the UI. There are some workarounds though: Workaround 1 (Downloads): There is a checkbox to remove sorting in the download modal.Workaround 2 (null dimension): This dimension will generate ORDER BY NULL which will help to optimize performan...

Technical Tips & Tricks

Article Does clearing cache clear the drill down cache?

Last tested: March 2021 No. When you clear cache, it only clears cache for the current query, not any cached results for the drill down.Workarounds The recommended workaround is to have a Datagroup set up on the explore, so that you're not relying on manual cache clearing. If you need to do this...

Technical Tips & Tricks

Article When would my Remote Origin URL start with `ssh://`?

Last tested: March 2021 When you're using a non-standard Git port. From git docs:URLs with custom or non-standard git ports can be used with Looker by adding the non-standard port number to the git URL. For example: ssh://git@corporate.git.server.com:22/myorganization/myproject.gitPlease note that...

Technical Tips & Tricks

Article SQL Error: "X is not a valid group by expression"

Last tested: March 2021 This SQL error means that that database is trying to group on something that it can't. Usually, this means that there are aggregates in a dimension definition.To troubleshoot, first try to isolate the field that throws the error. Then take a look at its LookML definition. One...

Technical Tips & Tricks

Article Using liquid 'split' to iterate (loop) over a string

Last tested: May 2020 This comes in handy when you has a comma-separated list and you want to format it or apply links to each comma-separated value.For example:List apple, banana orange, apple, banana Since the "list" fields can have either 2 values or 3, we can easily use the split function to...

Technical Tips & Tricks

Article Content Validator Quick Facts

Last tested: May 2020 The content validator checks to see which of your Looks and dashboard tiles are broken by LookML changes.DOES Replace models, explores, views, fields, fields used in table calculations and custom fields Remove models, explores, views and fields Check lookless tiles (Looker...

Technical Tips & Tricks

Article Why is my measure of type:count being made into a COUNT DISTINCT in the SQL?

Last tested: May 2020 A count measure usually creates a COUNT(*) in the SQL. However, if joins are involved, then a COUNT(*) would cause a fanout.So to avoid this, Looker generates a COUNT DISTINCT on the view's primary key instead. This should give you the same results as a COUNT(*) on that table w...

Technical Tips & Tricks

Article How can I make one column have a conditional format style based on another column's value?

Last Tested: Jan 21, 2019 This is possible using Liquid in the html: of a given LookML field. The example is not exactly highlighted in this community article, but it can help for a reference point. For example:Articlehtml:{% if value == 'Shipped' or value == 'Complete' %} Using Liquid _valuehtml:{%...

Technical Tips & Tricks

Article Can I choose the value for comparison in a Single Value Visualization?

Last Tested: Jul 3, 2018 Not by default, but we can use the offset function to adjust what value is shown. For example:#comparison table calculation columnoffset(${column_name},-2) You can adjust the "-2" as either a positive or negative value to customize the value. This content is subject to limit...

Technical Tips & Tricks

1
...
62
63
64
65
66
67
68

Page 65 / 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