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

Most replies

Recently active Most views Newest first

Article Can we hide schema in SQL Runner?

Last tested: Jan 20, 2021No, but here's a feature request to +1: https://portal.feedback.us.pendo.io/app/#/case/34511?section=requests This content is subject to limited support.

Technical Tips & Tricks

Article Can we disable curated search by default?

Last tested: Feb 11, 2021 Yes! You can disable it from Admin > General > disable curated searchhttps://docs.looker.com/admin-options/settings/general#curated_search This content is subject to limited support.

Technical Tips & Tricks

Article Is there a difference between data actions and "action hub"?

Last tested: Feb 12, 2021 In short, the action hub is the server that processes data actions => https://docs.looker.com/admin-options/platform/actionsAction hub is a full framework for managing api keys, integration settings and a few other things. There's an action hub server that sits between L...

Technical Tips & Tricks

Article Can we apply pivot over dimension?

Last tested: Oct 14, 2020 Yes, we can by using type: list in Measure field.measure: list {type: listlist_field: first_name}dimension: first_name {type: stringsql: ${TABLE}.first_name ;;} *NOTEtype: list creates a list of the distinct values in a given field. If two or more string value are included...

Technical Tips & Tricks

Article Default_locale on localization settings

Last tested: Feb 12, 2021 The default_locale is a parameter defined on the localization settings on the manifest file. It is important not to get confused with the instance locale we define on the admin page, even so they work together when se set custom localization.Considering the scenario where w...

Technical Tips & Tricks

Article Does the access_filter get extended when I extend an explore?

Last tested: Sep 8, 2020 Yes. We don't need to setup the access filter again, once the access filter from the original explore is also considered on the extended one.Considering the explore Users below, which contains an access filter on the field users.state:explore: users {view_name: usersaccess_f...

Technical Tips & Tricks

Article Can we hide filters in Looks?

Last tested: Aug 16, 2019 Short Answer: No.For custom filters: When you use custom filters in the explore and save it as a Look, we can't edit the custom filter on the Look. Even so the custom filter is not a dynamic filter and the user didn't really need to know what is being filtered. We can't hid...

Technical Tips & Tricks

Article Modularity: The "Building-Block" Approach to LookML Development

Last tested: May 21, 2018 Awesome video on the concepts for building a clean and scalable Looker model: This content is subject to limited support.

Technical Tips & Tricks

Article Tips For Debugging Actions

Last tested: Jul 6, 2020 Get the webhookIDs of the failing action. Map ID with logs on ActionHub Prod* Is it a streaming action?https://docs.looker.com/admin-options/platform/actions#list_of_integrated_services* If yes, do you use of the action use all_results? This will use more than 5000 results a...

Technical Tips & Tricks

Article What happens when a node in a cluster fails?

Last tested: Jan 10, 2020 Do the other nodes recognize the failed node?Indirectly, yes -- The node's aren't keeping an eye on each other directly (they aren't pinging each other) but the scheduling engine recognizes the node failure based on the internal db's node heartbeat table and will restart/re...

Technical Tips & Tricks

Article Tracking Schedules with System Activity

Last tested: Jan 27, 2020 The scheduled_plan System Activity explore is a great place to follow the movement of a schedule job through the different stages of a schedule job's lifecycle.You can access the scheduled_plan System Activity explore with the following link (replace company with your host...

Technical Tips & Tricks

Article What git commands are executed under the hood when the "Deploy to Production" button is pressed?

Last tested: Oct 15, 2018 You are in dev mode, working on a branch dev-john-smith-wxyz in the local repo in the looker/models-user-123/project-foo directory.When you commit, you commit to the local repo under looker/models-user-123/project-foo and also push your changes to the shared repo - github.c...

Technical Tips & Tricks

Article How to disable tooltip in chart entirely

Last tested: Apr 13, 2020 This is a feature request you can vote on our feedback system: Turn off tooltip capabilities on a look.Workaround:You are not able to in the measure, use an empty html parameter like so (ex: html: ;; ), because If you use an empty HTML parameter, you will see the IDE error...

Technical Tips & Tricks

Article What happens under the hood when you hit "reset connection" in Project Settings?

Last tested: Apr 7, 2020 When a user hits 'Reset Connection’ in Project Settings, Looker executes a function called revert_repo() calling two jgit commands, reset and clean:resetCommandBy default, reset simply changes the `HEAD` the current branch is pointing at. The `HEAD` reference is found with a...

Technical Tips & Tricks

Article OAuth Error: User not in the authorized domain(s)

Last tested: Sep 26, 2019 This generally occurs when the user's email domain (eg @looker.com) hasn't been added to the 'Authorized Domain' list on the OAuth side.This can also occur if the user's domain has not been verified on the GSuite / Oauth side.Note that even if the user's email address ends...

Technical Tips & Tricks

Article Filter If / Conditionally Filter / How can I filter only if a user doesn't use a filter?

Last tested: Sep 27, 2019 You can do this by using the `conditionally_filter' LookML parameter .This would be an explore level parameter (you would put it in the model file, in the definition for a given explore, and it would apply to that explore and all tiles or looks that use that explore as a ba...

Technical Tips & Tricks

Article ERROR: within group ORDER BY clauses for aggregate functions must be the same -- Redshift

Last tested: May 6, 2020 You are probably either using multiple MEDIAN() functions working on different columns together, or are using multiple other sort based aggregate functions together.Per Redshift documentation:If a statement includes multiple calls to sort-based aggregate functions (LISTAGG,...

Technical Tips & Tricks

Article What are the collection_id, palette_id, and custom_colors parameters in a LookML dashboard?

Last tested: Feb 13, 2020 You may be puzzled to see something like this on a LookML dashboard:https://docs.looker.com/exploring-data/visualizing-query-results/color-collections#color_collection_idsEssentially, in order to get your ids for your custom theme, you'll need to hit the /themes endpoint in...

Technical Tips & Tricks

Article No Results, Why doesn't my html render?

Last tested: Feb 5, 2020 Let's say you have this really nice html button that you coded up:But instead of seeing the button you see this, or "No Results":Under the hood, the html only will render if there are results in the returned table, even if you aren't using those results anywhere in the h...

Technical Tips & Tricks

Article Troubleshooting PDT Explore queries get sent straight to 'enqueued'

Last tested: Sep 28, 2020 The Problem:Users may report difficulty getting a PDT to build, specifically that a PDT query will go straight to queue, even though few other queries are running and the PDT is not the child of another PDT that is still building.You'll want to verify that this is the scena...

Technical Tips & Tricks

Article Dynamically display an image in a Dashboard, based on a filter

Last tested: Oct 30, 2019 There's a few components to this, but it's easier than you might think! At a high level we will be using Liquid and a bit of front end wizardry.1 - LookML ### we're starting with this field, which references a database column with customersdimension: customer {type: strings...

Technical Tips & Tricks

Article Azure SAML: AADSTS50011: The reply url specified in the request does not match the reply urls configured for the application

Last tested: Aug 19, 2020 Every case of this we have documented is due to some attribute of the /samlcallback url they're inputting into Azure being incorrect. Specifically:Not using the callback url, eg input https://instance.looker.com instead of https://instance.looker.com/samlcallback There is a...

Technical Tips & Tricks

Article How to dimension fill a string? Or how to have a dimension value that isn't in my dataset

Last tested: Mar 20, 2020 Easy, but more brittle way: LookML caseFor example, this code:dimension: status {type: stringcase: when: { sql:${TABLE}.status = "complete" ;; label:"complete" }when: { sql:${TABLE}.status = "pending" ;; label:"pending" }when: { sql:${TABLE}.status = "cancelled" ;; label:"c...

Technical Tips & Tricks

Article How do I get dates for this month up to yesterday?

Last tested: Nov 25, 2019 Create this in a table calc. It should result in yes/no values and you can filter out the nos.trunc_months(${date_column}) = trunc_months(now()) AND extract_days(now()) > extract_days(${date_column}) This content is subject to limited support.

Technical Tips & Tricks

Article How do I hide one value label?

Last tested: Apr 24, 2020 Let's say you have two or more measures, and want value_labels in your chart for only one but not the other?Answer:Method1 (Pre-7.0): Input transparent in the value label colors field. You'll also need to input another color for the other measure, or else both measure label...

Technical Tips & Tricks

1
...
59
60
61
62
63
64
65
...
68

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