User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started75 News & announcements105 Who's hiring390 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1380 SQL259
Exploring & curating dataExplores440 Dashboards & looks1204
Application developmentEmbedding Looker / Powered by Looker112 Open source projects46 Looker API297
AdministrationUser access & management24 General Looker administration379
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

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 Can you change the file name of a scheduled report?

Last tested: May 31, 2019 No. Please comment on the feature request: https://feedback.us.pendo.io/app/#/case/17616See this card for how files sent to SFTP and S3 are named: How are files sent to SFTP and S3 buckets named? This content is subject to limited support.

Technical Tips & Tricks

Article How do I make a Look/Dashboard full screen and remove the Looker banner? (Presentation and Embed mode)

Last tested: Feb 24, 2021 You can add /presentation/ or /embed/ in the URL of an explore, Look or dashboard. Both will make the content full screen and remove the top navigation bar. For dashboards next, you can add a parameter, print_mode=true to the URL. (/dashboards-next/1234?print_mode=true)Ther...

Technical Tips & Tricks

Article MYSQL—HowTo: Why does MySQL need database permissions for derived tables?

Last tested: Mar 9, 2021 At the time the code for the MySQL dialect was written, it did not support WITH, so we had to write derived tables a bit differently. Instead of WITH we use CREATE temp TABLE, which requires database permissions. (This is still different than a PDT since we are not writing t...

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

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 Can I access, develop or extend the System Activity model?

Last tested: May 12, 2020 No, at this time users cannot access, develop or extend the system activity model.There is a feature request open for comment for this functionality. This content is subject to limited support.

Technical Tips & Tricks

Article refs/heads/branch REJECTED_OTHER_REASON: pre-receive hook declined

Last tested: Apr 2, 2020 Some users enforce strict policies on their commits from their remote git provider. These sometimes come in the form of pre-commit or pre-receive hooks. These are essentially scripts that git executes before or after an event, like a commit, or a push, that check things such...

Technical Tips & Tricks

Article Is it possible to restrict Looker users to only be able to log in when they are connected to a certain network?

Last tested: Apr 13, 2020 If you are Looker-hosted, you can use the IP allowlist feature to restrict which IP addresses can access the Looker application.If you are self-hosted, you can configure your own network to allow which IP addresses have access. This content is subject to limited support. ...

Technical Tips & Tricks

Article Slack Action (the Slack Attachment API Token) won't show Channels

Last tested: Nov 6, 2019 Are you trying to send data from Looker to Slack? Can you see user names, but no Slack channels in the drop down menu? You've come to the right community article!Troubleshooting:Step 1: Make sure you're talking about Action HubCheck this Sending Data from Looker with the Sla...

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 Using {{_explore._name}} to extend Explores using the `from` parameter

Last tested: Sep 6, 2019 There are occasions when you have an explore where you need to use from to specify the view to use for an aliased Explore. If this Explore is then extended by another Explore, the fields must be referenced with the Explore name (instead of the view name) so you'll see an err...

Technical Tips & Tricks

Article How do I hide one of my pivot columns?

Last tested: Mar 16, 2020 If you find yourself here, +1 this feature request: https://feedback.us.pendo.io/app/#/case/17612We're here, and we want to hide the "other" column:We can accomplish this with pivot_index or pivot_where.You'll need to create a table calculation for each column you want to s...

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

Article Detailed Steps to "More Powerful Data Drilling" & how to get vis configs for custom drilling

Last tested: Dec 15, 2019Enable the “visual drilling” labs feature. In the `drill_fields` parameter within the definition of a measure we’d like to drill into, we select only the fields we want to see in the drill modal. Go to the explore and drill into the measure. We should be seeing some default...

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

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 Can Looker use Stored Procedures?

Last tested: Jan 21, 2019 NoThere is a semi-workaround for this with the `create_process` parameter with sql_step subparameters. If your database dialect uses custom Data Definition Language (DDL) commands, you can use create_process to create PDTs, by defining a list of SQL statements that will be...

Technical Tips & Tricks

Article How to build a dynamic link parameter for different dashboard ID between dev and production environments

Last Tested: Jun 25, 2020 ProblemUsing relative links (/dashboards/410) vs. absolute links (https://abcdefg.looker.com/dashboards/410) will correct for differences in the base domain, but will not accommodate for differences in dashboard ID between dev and production instances.SolutionIf a dashboard...

Technical Tips & Tricks

Article How to log embed users out of Looker when they log out of the application?

Last tested: May 7, 2020 The ProblemAn application will log embed users into Looker, but when they log out of the application, they will not be logged out of Looker.A SolutionLooker does not use a /logout endpoint for web sessions. Instead, you will need to make calls to Looker's user_sessions endpo...

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

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 DCL Mic Drop: Won Park

DCL Mic Drop #2The Department of Customer Love (DCL) is Looker’s all-knowing support team. Yes, they're actually called that. They’re kind of the brains behind this whole operation! You may have talked to them via support chat or on a ticket, or maybe even in the Looker Community. Talking to DCL, I...

DCL Mic Drops

Article Default Explore/Drill Sort (Order By) Behavior

Last Tested: March 15, 2021 In the explore and drill menus, Looker chooses a default field to sort on: The first date dimension, descending. If no date dimension exists... The first measure, descending. If no measure exists... The first added dimension (ascending) As of Looker 4.10, these defaul...

Technical Tips & Tricks

Article CASE WHEN in table calcs

Last Tested: March 22, 2021Though a case when in table calcs is currently a feature request (see https://feedback.us.pendo.io/app/#/case/32191), you can make it work with nested if statements. If you use coalesce, it becomes even more readable:coalesce( if(${field} < 1, "Less than 1", null), if($...

Technical Tips & Tricks

1
2
3
4
5
...
68

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