User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started79 News & announcements106 Who's hiring395 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1439 SQL265
Exploring & curating dataExplores447 Dashboards & looks1235
Application developmentEmbedding Looker / Powered by Looker118 Open source projects46 Looker API304
AdministrationUser access & management27 General Looker administration386
Data science & analyticsGot a question?62 Share your best practices13
コミュニティフォーラム (Japanese)ニュースと告知35 ヘルプとサポート11 コラム55
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
99 Replies

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

1659 Topics

Most views

Recently active Most replies Newest first

Article SQL Error: "Syntax error at or near:"

Last tested: Feb 2021 Overview This SQL error generally means that somewhere in the query, there is invalid syntax.Some common examples:Using a database-specific SQL for the wrong database (eg BigQuery supports DATE_ADD, but Redshift supports DATEADD) Typo in the SQL (missing comma, misspelled wor...

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

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 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 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 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 SQL Pattern: How can I count the number of comma separated values in a string?

Last tested: Aug 16, 2017 This might not be a common request, but the method to do so is below:SELECT (LENGTH(Col2) - LENGTH(REPLACE(Col2,",","")) + 1) AS MyCol2CountFROM MyTable Basically, you replace all occurrences of , with an empty string "", then subtract its LENGTH from the LENGTH of the unad...

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 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 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 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 Can I filter data using table calculations?

Last Tested: Feb 4, 2019 Indirectly yes, example in Looker Docs here.The trick is to use "hide no's from visualization". This requires you to have your "filter condition" as a boolean table calc.Note that this isn't actually filtering in the SQL clause, and that this will only work on result sets wi...

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

Article Can I group or bucket by table calculations?

Last tested: March 2021 No. Table calculations are computed after SQL grouping, so it's not possible to group by them.Only dimensions can be grouped on. Consider using a custom dimension for quick grouping! https://docs.looker.com/exploring-data/adding-fields/custom-measure#creating_a_custom_dimensi...

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

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

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