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

Recently active

Most replies Most views Newest first

Article How do I get a measure to listen to one filter and not another?

Last tested: June 2020 If you use a filter field, then you can specify which measures should listen to that filter field using templated filters.This Help Center Article explains it well; here are the code examples from that article.filter: status_filter { type: string}dimension: status_satisfies_fi...

Technical Tips & Tricks

Article If a user is assigned multiple user attributes via groups, which value takes precedence?

Last tested: March 2021 From docs: When a value is assigned to multiple groups you’ll need to decide which group should take precedence, in case a user belongs to multiple groups. To do so, drag the groups into the order that should apply; each group takes precedence over the groups listed below it....

Technical Tips & Tricks

Article Can I show only one table calculation column when using a pivot field?

Last Tested: Sep 17, 2019 Users may end up using Table Calculations when pivoting and this leads to a table like:|| Col_1_Pivot | Col_1_Table_Calc | Col_2_Pivot | Col_2_Table_Calc ||Users will then only want to show the table calculation column(s). This is possible, but we will have to use the pivot...

Technical Tips & Tricks

Article Connecting to Multiple Snowflake Databases

Last Tested: Dec 18, 2020 Setting Up Connection to Support Multiple Databases- Nothing extra required. Connect to Snowflake as normal and communication with all DB's within the warehouse is supported by default.But the Connection Requires Me to Specify a Database Name- This is still need because Loo...

Technical Tips & Tricks

Article Can I see a list of all User Attributes in System Activity?

Last Tested: Sep 4, 2019 No, User attributes are encrypted and at this time we do not have access to them in system activity. There is a request for this to be made available. Here is a neat API workaround on Community. This content is subject to limited support.

Technical Tips & Tricks

Article How do I get an image or gif on my dashboard's text tile or project readme?

Last Tested: May 15, 2020 Option 1: IF YOU HAVE A PUBLICLY ACCESSIBLE URL TO THE IMAGEYou can do this by using html in the title, subtitle, or body parameter of your text tile. Note, that the image you'd like to display needs to be on the public internet (practically speaking, what this means is tha...

Technical Tips & Tricks

Article Why can't admins see data when we implement User Attributes with Access Filters?

Last Tested: Apr 29, 2019 Even Admins Must Have Filter Values Set in the UIEvery user who accesses an explore that uses access_filter must have a value in the referenced user attribute. This even applies to Admins, despite the fact that they can see all data. Users who don’t have a user attribute va...

Technical Tips & Tricks

Article What happens when a non-admin user is given `see_users` on a closed system?

Last Tested: Jul 3, 2018 A user granted this permission can see all users in all groups on an instance, even on a closed system. Non-admins with the see_users permission can see ALL users in the system, not just those in their same user group. This content is subject to limited support. ...

Technical Tips & Tricks

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 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 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 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 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

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