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

How do I apply one filter to multiple fields?

The Use Case: Say you want to have a single filter apply to two separate fields (fields A and . The end goal is to be able to update both fields with a single filter, to avoid forcing an end user to type in the same filter value into 2 filters. There are a few ways to achieve this! The Solution(s...

Technical Tips & Tricks

Article Does Looker support IAM Roles based authentication for Athena in Looker?

Last tested: Nov 14, 2017 This isn't possible at the moment. User will need to enter the ID and secret for the role in the connection instead. This content is subject to limited support.

Technical Tips & Tricks

Article Query task [hash] results not found in cache

Last tested: Aug 19, 2021 This error will happen on some merged result query runs, usually as a result of the cache being busted for one of the source queries.Merged queries essentially work by running all source queries asynchronously, and then once all queries are marked as complete, the results o...

Technical Tips & Tricks

How do I get a list of recently viewed dashboards by a user through the Looker API?

1 ) Hit login_user to login as the user (https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/api-auth#login_user)2) Use all_dashboards endpoint to get all the dashboards the user has access to and sort it on the last_viewed_at param

Technical Tips & Tricks

how to return first row of data

The problemLet's say you have a table like so:And you want to return only the first row of data in a single column. The solutionWe can accomplish this by using this function here:pivot_index(index(${number_of_sign_ups.count}, 1), row()) The explanationIndex(orders.count, 1) is specifying to return v...

Technical Tips & Tricks

how to check if every unique value of sql_distinct_key has one corresponding value in sql

The problemIf you are getting Non-Unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum error and you've checked that you have a primary key and are also using a sum_distinct with sql_distinct_key, you should check to make sure your sql_distinct_key only has...

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

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

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

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

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

Article How do you reference a yesno dimension field value?

Last tested: March 2021Looker’s “yesno” dimensions return boolean values (TRUE or FALSE) rather than a string “yes” or “no”. For this reason, when SQL is involved, you don’t need to write “field == yes”, you can simply write “field”, as this will return TRUE or FALSE by itself. Here are specific exa...

Technical Tips & Tricks

Article PDT Naming Convention

Last Tested: Jun 25, 2021 PDT name structure:LR$[connection_key][hash]_[view_name]All PDT names begin with LR, short for Looker Read. The connection_key is a two letter string that is unique for the connection. The PDT hash is an encoding slug that follows the connection_key and precedes view_name i...

Technical Tips & Tricks

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

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

Article What Looker version am I running?

Last Tested: Jun 14, 2019 Here are two different options:Click on the question mark icon in upper-right section of your Looker instance. Your version number will be shown to the right of the Release Notes section. Right click on the Looker login page in chrome and click "View Page Source". You can s...

Technical Tips & Tricks

Article Week-related table calculation functions

Last tested: Dec 2, 2019 Currently, there are no week-related table calculation functions available. Below are feature requests and workarounds for various week-related functions.extract_day_of_week / extract_day_of_week_indexA function to extract the day of the week or day of week index from a date...

Technical Tips & Tricks

Article Dev Mode PDTs

Last tested: Sep 9, 2019 A PDT that has been created/modified in a user's dev mode has the following properties:It behaves as if it has persist_for: 24 hours regardless of what persistence is set. Each one will be its own table in the scratch schema (see "Why are there multiple copies of the same PD...

Technical Tips & Tricks

Article How to sort by rolling month

Last tested: Oct 4, 2019 To sort their data by current month for ex: October 2019 thru November 2018, you can throw this in the lookml (dialect specific may be required): dimension: this_month_num { hidden: yes sql: MONTH(CURDATE());; } dimension: sort_relative_month { type: number sql: C...

Technical Tips & Tricks

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

Article Error: Unknown view. View does not exist in model. Check for typos or missing include statements.

Last tested: March 2021ProblemYou receive a LookML error that complains about an unknown view. The error takes the form:Unknown view “my_view”. View “my_view” does not exist in model “my_model”. Check for typos or missing include statements in “my_model”.Solution 1The most simple reason for this err...

Technical Tips & Tricks

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

Article How can I investigate why my instance is so slow?

The first thing you want to do is figure out which dashboards are the slow performers. Our System Activity Pages will give you performance statistics and help with your investigation. Below are some impactful changes you can make for optimizing Looker query performance: Build explores using many_to...

Common Account Questions

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

1
2
3
4
5
6
7
...
68

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