User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started77 News & announcements105 Who's hiring391 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1395 SQL261
Exploring & curating dataExplores443 Dashboards & looks1212
Application developmentEmbedding Looker / Powered by Looker114 Open source projects46 Looker API299
AdministrationUser access & management25 General Looker administration381
Data science & analyticsGot a question?62 Share your best practices13
コミュニティフォーラム (Japanese)ニュースと告知35 ヘルプとサポート11 コラム54
The Kitchen TableTechnical Tips & Tricks1659 Common Account Questions14 DCL Mic Drops5

Ask question / Create topic
Login

The Kitchen Table

Explore the product knowledge we've built up together

1678 Topics

Most replies

Recently active Most views Newest first

3 Methods of Embedding Looker Content

You want to embed your Looker content into another website. How should you do it? There are 3 main methods of Looker embedding. Choose the one that best fits your use case.The easiest type of embedding to set up is Private Embed. The only setup is to insert the URL to your Look or dashboard inside a...

Technical Tips & Tricks

Common Questions About GitHub Authentication Changes Made on August 13th

What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you’ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this af...

Technical Tips & Tricks

How to hide the field label on a pie chart or customize the measure label.

Hi all, A few customers have used the pie chart visualization and wanted to remove the measure label from the Tool Tip or hover state. There is no direct way to do this right now, but we can use a table calculation and a blank space character to hide the label from the visualization. In our example...

Technical Tips & Tricks

Why Doesn't My Table Calculation Work in My Visualization?

The ProblemThe data is set up how you would like, but when you select the visualization type, Looker says that the visualization is incompatible with your data (e.g. it requires one dimension and one measure). The ExplanationEven though the “Percent Profit” table calculation is performing a mathema...

Technical Tips & Tricks

Why does it show the faceted filter icon even though there aren't any faceted filters enabled?

The problem:Sometimes, you can encounter a situation where you see the faceted filters icon even though there aren't any faceted filters enabled on the dashboard and then when you hover over the faceted filter icon, you see this... The explanation:Some ways this can happen is if the you created a Lo...

Technical Tips & Tricks

Why is it necessary to domain whitelist when user attributes values are set to hidden?

Hidden user attributes tend to be passwords or tokens so whitelisting URLs restricts where those passwords or tokens can be sent. You wouldn't want someone doing something like, I'm going to use this user attribute on a schedule to a random place so that I can see the value of it.

Technical Tips & Tricks

Can we have the same external_user_id for all users logging into embedded content?

Technically, the answer is yes. However, there are potential issues to consider:As noted in docs, this value must be unique for a given set of permissions, user attributes, and models. So, for example, if the different users will have different permissions, they’ll need two different external user I...

Technical Tips & Tricks

Article Why am I getting `Uh Oh. GATEWAY_TIMEOUT` when downloading a dashboard PDF?

Last tested: Jul 4, 2018 This error implies a network timeout. Check for a load balancer on your end. On Looker nginx servers sample we use a timeout of 3600 seconds, which can be customisable to your environment. This content is subject to limited support.

Technical Tips & Tricks

Article What is LEXP?

Last tested; Jun 4, 2021 LEXP stands for Looker Expressions. It is a special syntax created by Looker that is used for Table Calculations, Custom Fields, and Custom Filters. We have a doc that outlines the general usage of expressions, and another doc that has a list of all functions that it current...

Technical Tips & Tricks

Article month_x timeframe

Last tested: Feb 3, 2019 This came from a custom month_18 (group by every 1.5 years) timeframe in redshift. Here is a generalized version for month_x where you can shift the start month by adjusting y: dimension: month_x { type: string sql: TO_CHAR(DATE_TRUNC('month', #Convert...

Technical Tips & Tricks

Article How does one resolve an issue with setting up the shared filesystem where the uid and gid are different on the share than they are on the looker server?

Last tested: Aug 21, 2020 The UID and GUID need to match.As root, you can edit /etc/passwd and /etc/group on one host to make it match the other, then do a chown -R looker:looker /path/to/shared/whatever This content is subject to limited support.

Technical Tips & Tricks

Article Why are my email fields grey?

Last tested: May 10, 2018 There are two different interpretations of this question, with two different answers.1. On the Admin > User page, before editing a user. If an email is grey here, it means the user can't log in with these credentials. In this example, SAML is enabled for the instance. Us...

Technical Tips & Tricks

Article Is model localization also applied to UDD?

Last tested: Feb 12, 2021 When we apply localization on the model level, some elements would be localized on explores, looks and user defined dashboards, as for example labels, group labels and descriptions and even data values. Take a look on the docs for more elements that can be localized on the...

Technical Tips & Tricks

Article Access to font at ' S3 bucket' from origin 'https://ait.dev.att.com' has been blocked by the CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource

Last tested: May 20, 2020 If you are seeing this error on your JS console for your embed contentThe solution is to set on the S3 bucket settings: https://docs.aws.amazon.com/AmazonS3/latest/dev/cors.html the configurations to accept it.We've had users that confirmed it worked after enabling the Acce...

Technical Tips & Tricks

Article How to apply access_filters to views

Last tested: May 6, 2020 The ProblemI have an access_filter for one of my explores. But I'd like to use it for a view instead so that it will automatically come through for all explores which use this view.A WorkaroundWe can replicate the functionality of access filters in views by referencing the u...

Technical Tips & Tricks

Article Should I hide or delete unnecessary LookML fields?

Last tested: Aug 6, 2020 The ProblemI have some LookML fields that I'm not using. They are currently hidden with `hidden: yes`. I'm concerned that it may be a performance cost to keep them. Should I delete them to save database strain?An AnswerWriting a field in LookML does not immediately query the...

Technical Tips & Tricks

Article 400 Bad Request when downloading dashboard zip csv

Last tested: Mar 31, 2020 Pre 7.2: if a query fails to run for any reason (a DB error, a problem with table calc syntax, etc.), the cache will not be set but the invalid cache entry will still be retrieved, throwing an Error streaming dashboard-my_dashboard/my_tile.csv to out error. Version 7.2+: Th...

Technical Tips & Tricks

Article Get changes back after revert to production

Last tested; Jul 7, 2020 Say you accidentally push some changes to production - your coworker reverts those changes, so production is all set, but you wanted some of those changes to continue working on. How can you get them back?In History, from either the git menu in Looker or in the remote provid...

Technical Tips & Tricks

Render job error: `query failed: Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.`

This error message is being returned from the database and is a standard MS SQL error. One of the most common causes for this deadlock error is when a large table scan conflicts with an update.For more information on this error, check out this helpful Stack Overflow post. This content is subject to ...

Technical Tips & Tricks

What does the graph_derived_tables_for_model endpoint do?

You can use the graph_derived_tables_for_model endpoint (documentation) to get a dependency graph of all the PDTs in a specific model in the DOT language. The output can then be rendered into an image by passing the output into a graphviz tool. The rendered image will look something like: This cont...

Technical Tips & Tricks

Can you add, edit, or update table calculations in Looks via the API?

Yes, you can update the query object associated with a Look. There's a property called dynamic_fields which you can use to add, update, or remove table calculations.To get the logic for the table calcs, you can build a query with table calcs, open up Dev Tools, look at how Looker constructs the quer...

Technical Tips & Tricks

Article My schedules are freezing / not delivering. What should I do?

In order to troubleshoot any kind of scheduled delivery failure (SMTP issues, scheduler hiccups, emails not being delivered, etc.) you will need to file a ticket with our DCL chat support team. To get in touch with chat support, please visit our Help Center page or access the chat option directly i...

Common Account Questions

Article Can I get more information on migrating from self hosted to Looker hosted?

If you are interested in migrating to Looker Hosted, contact your Field Sales Representative to get the process started. It takes time to collect all the information needed to have a successful migration. We are here to help!To start out, your FSR will ask you a few questions. These will be provided...

Common Account Questions

Why am I not getting emails about changes to my Looker instance?

Not receiving important update emails about your Looker instance? You might not have designated a technical contact for your account, who is automatically signed up to receive important notifications such as security updates, major bug fixes, and new Looker releases. Designating this role for your a...

Common Account Questions

How do I filter results in my visualization, without filtering out rows in the data tab?

The Problem:I have a use case where I need to filter out rows in my visualization, but need all the rows to remain in the data tab. For example, I have a calculation/aggregation that relies on all the rows being in the results, and when I use a regular filter, the results of the calculation/aggregat...

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

© 2020 Looker Data Sciences, Inc.
Privacy | Terms | Cookies | Community Guidelines