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 SQL261
Exploring & curating dataExplores443 Dashboards & looks1211
Application developmentEmbedding Looker / Powered by Looker113 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

Technical Tips & Tricks

Previously internal product knowledge now available for you to explore!

1,659 Topics
82 Replies

When you subscribe we will email you when there is a new topic in this category

1659 Topics

Recently active

Most replies Most views Newest first

Article Selected articles about Looker API & SDK use cases

We have gathered a list of community and help center articles covering some major API & SDK use cases. We hope this makes it easier for you to browse and navigate. The code examples are for demo purposes only. For any further questions on those use cases please post a comment under those article...

Article Selected articles about LookML

Selected articles about LookML We have gathered some selected community and help center articles and organised them in different topics. Hope this makes it easier for you to search and navigate. General Why do we recommend many_to_one joins over one_to_many joins?How to add a new row of data with Lo...

Article Selected articles about SQL use cases in Looker

Selected articles about SQL use cases in Looker We have gathered a list of community and help center articles organised in different topics. Hope this makes it easier for you to search and navigate. TroubleshootingCommon SQL error troubleshooting tips in Looker Calendar tableHow to combine a retail...

Article Breaking News: Knowledge Drops are LIVE!

Democratizing information has always been a core tenet of Looker’s values. It’s how we all become better thinkers and better doers. This ethos isn’t just a philosophy or a catchy marketing phrase; it’s a practice - and it’s one we’ve always taken to heart. So in true Looker-fashion, we’re excited to...

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

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

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

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

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.

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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.

1
2
3
4
...
67

Page 1 / 67

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