User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started61 News & announcements103 Who's hiring376 Release notes (archive)63 Lesson Comments10 Challenge8
Looker developmentLookML1309 SQL253
Exploring & curating dataExplores421 Dashboards & looks1142
Application developmentEmbedding Looker / Powered by Looker99 Open source projects44 Looker API281
AdministrationUser access & management19 General Looker administration373
Data science & analyticsGot a question?59 Share your best practices11
コミュニティフォーラム (Japanese)ニュースと告知34 ヘルプとサポート10 コラム54
The Kitchen TableTechnical Tips & Tricks1647 Common Account Questions15 DCL Mic Drops5

Ask question / Create topic
Login

Technical Tips & Tricks

Previously internal product knowledge now available for you to explore!

1,647 Topics
46 Replies

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

1647 Topics

Most views

Recently active Most replies Newest first

Article Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials

Last tested: Jan 20, 2021If you're seeing this error, check to see if the table that is being queried is a google sheet that's stored in Drive.If that's the case, make sure that the Service Account for BQ that Looker is using has access to the Drive. This content is subject to limited support. ...

Article Parsing JSON data in Looker

Last Tested: Apr 3, 2019 Looker doesn't have a native JSON field type.Workaround 1: SQL OperatorsYou'll want to use JSON parsing functions in SQL, like json_extract_path in Postgres and JSON_EXTRACT in BigQuery to extract the JSON and put it into a type that Looker can accept, like a string.There ar...

Article Advanced LookML - Liquid Use Cases

Last tested: Aug 28, 2019 Liquid is an open-source, Ruby-based template language created by Shopify It can be used in conjunction with LookML to build a more flexible, dynamic code.Liquid code is denoted by braces { } and falls into 3 different categories:TAG: {% %}used to create logicOBJECT:{{ }},...

Article How do I get an image or gif on my dashboard's text tile or project readme?

Last Tested: May 15, 2020 Option 1: IF YOU HAVE A PUBLICLY ACCESSIBLE URL TO THE IMAGEYou can do this by using html in the title, subtitle, or body parameter of your text tile. Note, that the image you'd like to display needs to be on the public internet (practically speaking, what this means is tha...

Article Pull Production Failed Failed: Cannot pull into a repository with state: MERGING_RESOLVED

Last Tested: Sep 20, 2019 How did I get into this state?The most typical scenario that this error appears is as follows:Two developers working on the same [shared] branch The first developer changes something on a given file (lets say fileA.txt) The second developer on its local repo rename the file...

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

Article How to cache a dashboard

Last Tested: Apr 1, 2019 You have two options here.Instant DashboardsThe first option is to use instant dashboards. With instant dashboards, dashboards display the previous run’s data while new queries are run in the background, letting information appear quickly. This is a labs feature. More inform...

User does not have bigquery.jobs.create permission in project error

If we are hitting the error “BigQuery connection is hitting this error User does not have bigquery.jobs.create permission in project `project_name`” for a connection where we have granted the user the BigQuery Data Editor and BigQuery Job User role already then we may need to check our value for th...

Article How do I do a ROW_NUMBER OVER (PARTITION BY ...) with a table calc?

Last Tested: Jul 1, 2018 match(${products.brand},${products.brand})if(${partition}=offset(${partition},-1) , 1+row()-${partition} , 1 This content is subject to limited support.

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 Important: Supportability of Knowledge Drops

We will not be updating Knowledge Drop content, nor do we guarantee that everything is up-to-date. The timestamp published on each Knowledge Drop denotes when it was last verified. We have spent years building up this treasure trove of insightful Looker tips, tricks, and how-to’s, but given how quic...

Article How can I recover a deleted Look or Dashboard if the trash is emptied?

Last tested: March 2021 As of 4.8+, all deleted content goes to the Trash Folder. It stays there indefinitely until deleted by an admin. Any content can be restored from the Trash Folder by an admin.This card talks about how to find and restore a deleted Look or dashboard with i__looker, in the cas...

No Matching Signature for operator >= for argument types: TYPE, OTHER TYPE

SQL Error Series #1: Type Errors Post Context: This content is adapted from our internal SME (Subject Matter Expert) curricula. Similar to knowledge drops, this content may be highly Looker specific and may become out of date in the future. The goal is to convey a high level understanding of a commo...

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 Can I change font size in visualizations?

Last Tested: Jul 11, 2019 It is currently not possible in all visualization styles. But this time we have font control over values in the following visualizations - Bar, Column, Scatterplot, Line, Area.We can also create a “single value visualization" out of a scatterplot which allows us to edit the...

Article Refused to display 'https://somedomain.com' in a frame because it set 'X-Frame-Options' to 'sameorigin'

Last tested: Nov 7, 2018 Let's conquer this beast.First things first. What the heck is an origin?It's the combination of protocol, domain, and port:{protocol}://{domain}:{port} --> https://developer.mozilla.org:443 OK, Got it. What about sameorigin?It's a policy designed to prohibit the display o...

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 Why isn't embed working in Safari? Are there browser settings we need to set for SSO embed content?

Last tested: Jan 21, 2021 Some browsers have their nuances.Safari and firefoxSafari disables third party cookies by default if the user has not previously visited the host of the iframe, so users will have to enable third party cookies in their privacy settings by disabling the setting Prevent Cross...

Article How to join the same table twice (self-join)

Last Tested: March 22, 2021In a given explore, each join name must be unique. To self-join the same table multiple times you can use the from parameter, as mentioned in the docs, to change the "join" name of the table.In this example, we join in person to order twice, with different names and differ...

Article How can I display a decimal number in hh:mm:ss format?

Last Tested: Jan 21, 2019 If your value is a number of seconds, divide the number by 86400.0 (the number of seconds in a day) and then use the value format hhss.NOTE that this is like a time, and will show you the 24-hour time modded by day. So if you had 25 hours, it would show 01:00:00 rather...

Article Filter on this month but also see previous month's data

Last tested: May 2020 The ProblemYou want to give your users a single date selector, where they can choose a month. Then, when they select a month, they should see data from that month and the previous month.Filtering for this month on a date dimension will remove any data from the past month, unfor...

Article Advanced LookML - Cohort and Retention Analysis

Last tested: Jun 24, 2019 What is a Cohort Analysis?Read this data tutorial here (5 minutes) and check out this introduction video to learn about the fundamentals about cohort analysis: What’s the point of Cohort Analysis?The goal of a cohort analysis is to analyse the performance of cohorts relativ...

Article How do I filter out null in a filtered measure?

Last tested: May 2020Most of these examples can be found in the filter expressions doc.Filter out NULL values for non-number dimensionsThe most common filter syntax to filter out nulls is simply "-NULL" . This works for most data types that aren't numbers, such as strings, dates, etc.measure: count...

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 How do I delete branches in the Looker UI?

Last Tested: March 22, 2021As of 5.12, it is possible to delete certain git branches in the Looker UI in the project settings interface of the lookml project, under Branch Management. You cannot delete the following branches: The production branch Your current branch A Looker developer’s persona...

1
2
3
4
...
66

Page 1 / 66

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

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