User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started77 News & announcements105 Who's hiring390 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1386 SQL260
Exploring & curating dataExplores443 Dashboards & looks1210
Application developmentEmbedding Looker / Powered by Looker112 Open source projects46 Looker API299
AdministrationUser access & management24 General Looker administration380
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

Recently active

Most replies Most views Newest first

Article Can I download a dashboard as a CSV or PDF via the API?

Last tested: Sep 27, 2019 For PDF: Yes. Use create_render_task() to schedule a job to render a dashboard (or other content) as a PDF file.Use render_task(id) to check the status of the render task. When it completes, use render_task_results() to fetch the PDF file.Note that PDF files are binary data...

Technical Tips & Tricks

Article How Looker does timezones and how to troubleshoot them

Last tested: Feb 1, 2021 Timezones, yikes!You may need to troubleshoot timezones to answer questions like:Why isn't Looker converting timezones correctly? Why is the timezone CONVERT SQL wrong? Inaccurate? Is there a timezone conversion bug? My finance team says timezone conversions are incorrect be...

Technical Tips & Tricks

Article How to preserve JS Embed Event message passing across page changes in iFrame

Last tested: Sep 10, 2020 When navigating pages within an iFrame, the embed domain is dropped from the iFrame src then the parent page will no longer receiving messages. Meaning that if you are using JS embed events and are intending those to persist across page changes you will want to make sure th...

Technical Tips & Tricks

Article Is Looker training free?

Many of our training materials are currently available to you at no cost. However, there are some that do have an additional fee. See below for a full list of offerings: Looker Connect is our new training platform and has learning pathways for data consumers and developers. Check out the “Getting St...

Common Account Questions

Article Mirror SAML Groups (idP group name matches Looker group name)

Last tested: May 19, 2020 When "Mirror SAML Groups" is toggled on in your instance's SAML settings, it will create a new group in Looker based off of the IdP-side group you input.A question was asked, "if the IdP side group has the same name as an existing Looker group, will saving those settings me...

Technical Tips & Tricks

Article Can I schedule to Google Drive?

Last tested: Jul 10, 2017 Yes! We have a Looker Action for Google Drive you can enable on the admin/actions page. You will find more details on this article: Looker Actions – Google Drive. This content is subject to limited support.

Technical Tips & Tricks

Article Show or hide value labels on a specific series

Last tested: Mar 31, 2021 There isn’t a native option in the visualization edit panel to toggle value labels on/off for individual series, but please leave feedback for the Looker product team! After authenticating into the feedback portal, you can click here for the open request!Two other options y...

Technical Tips & Tricks

Article Window Functions in Looker

Last tested: April 2021 How do I use window functions in Looker?Window functions are a very powerful tool in SQL because they perform post-aggregation calculations. There are three main ways to implement window functions:1: Use Table CalculationsCalculating after aggregations is exactly what table c...

Technical Tips & Tricks

Article Pass an external value to an embed URL as a filter

Last tested: Jul 17, 2020 Say you have a php script which is storing the value when a user visits your website. You have embedded content on this page, and would like to pass that value into a filter on the dashboard.Here you could have 2 options: Javascript eventsYour could explore .js events, and...

Technical Tips & Tricks

Article My filter suggestions are broken for nested data in Big Query

Last tested: Oct 7, 2019 Add the parameter full_suggestions: yes to the dimensionWhy does this work?The recommended strategy for handling nested fields in BigQuery is to create separate views for the nested fields and join them to the original table in the explore. The default full_suggestions: no c...

Technical Tips & Tricks

Article Dashboard-next description

Last tested: Nov 20, 2020 The ProblemDashboard-next doesn't currently have description option in the settings panelA SolutionRevert to dashboard legacy, add description in the setting panel and then upgrade to dashboard-next again.You can vote for this feature request on our feedback system. This co...

Technical Tips & Tricks

Article Faceted Filters in Explores (workaround)

Last tested: Nov 26, 2020 Faceted (linked) filters in explores aren't possible in Looker. Be sure to give a +1 to the feature requestSituation:Let's say we two have two filters on an explore page: Country and State. We want the State filter to populate based on the Country filter's selection.Steps:A...

Technical Tips & Tricks

Article List of workarounds for sorting pivots by measure / sorting by column totals / dynamic top n ranking

Last tested: Jul 13, 2018 The problemSay you want to see some metrics for your top 10 customers by number of users, where the customer dimension is pivoted. Currently there is no easy way from an explore to sort a pivoted dimension based on measure values—you can only sort the pivoted dimension alph...

Technical Tips & Tricks

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

Article The PDT Regenerator Process

Last Tested: Nov 4, 2020 Purpose:The regenerator's purpose is to manage the building of PDTs on the scratch schema. Its major tasks are to check datagroup triggers, build new PDTs that have been pushed to production and rebuild existing production PDTs whose trigger values have changed.Number of Reg...

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

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

1
2
3
4
...
68

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