Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started183 News & announcements134 Who's hiring452 Release notes (archive)63 Lesson Comments17 Challenge10
Looker developmentLookML2065 SQL342
Exploring & curating dataExplores627 Dashboards & looks1766
Application developmentEmbedding Looker / Powered by Looker183 Open source projects58 Looker API413
AdministrationUser access & management86 General Looker administration493
Data science & analyticsGot a question?100 Share your best practices17
The Kitchen TableTechnical Tips & Tricks1743 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥5
コミュニティフォーラム (Japanese)ニュースと告知52 ヘルプとサポート14 コラム73

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2114 Topics

Most views

Recently active Most replies Newest first

romain.ducarrougeLooker Staff

published in Technical Tips & Tricks

Get the second max value with table calcKnowledge Drop

Last tested: Jun 1, 2018 We can use the approach below to exclude the max value using and if() then applying a max on the remaining valuesmax(if(${orders.count}!=max(${orders.count}), ${orders.count}, null)) (and so on for 3rd max...) For pivoted results:max(pivot_row(if(pivot_index(${orders.count},pivot_column())!=max(pivot_row(${orders.count})), ${orders.count}, null))) This content is subject to limited support.

700

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Is it better to use the running_total measure or to use Table Calculations to perform a running_total?Knowledge Drop

Last tested: Jan 21, 2019 This can vary on your use case; however, Table Calculations provide more flexibility as they are run after your the Explore page returns results.This point is important to consider when your Explore results table has Pivoted Columns. Pivots will impact the Measure of `type: running_total`. In cases where a query is pivoted, running_total runs across the row instead of down the column. If this is not desired, add direction: column to the measure definition. This content is subject to limited support.

700

1 year ago

Dean_HicksLooker Staff

published in Technical Tips & Tricks

Types of AlertsKnowledge Drop

Last tested: Mar 17, 2020 There are three main types of alerts. Single value- only used on single value visualizations.- should alert based on the value used in the vis (first row only)Time Series- used when there is a date/time dimension on the result- checks all new rows that have not been seen before (based on the time series dimension)Categorical- used when not single value or time series.- checks all rows and pivot values unless a specific row or pivot value was selected when the alert was created. This content is subject to limited support.

700

1 year ago

mandy.chanLooker Staff

published in Technical Tips & Tricks

Render job error: `query failed: Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.`

This error message is being returned from the database and is a standard MS SQL error. One of the most common causes for this deadlock error is when a large table scan conflicts with an update.For more information on this error, check out this helpful Stack Overflow post. This content is subject to limited support.

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

What happens when a null is concatenated with a value?Knowledge Drop

Last tested: Jan 21, 2019 Just like arithmetic operations on a list, a null will make the entire result null. This content is subject to limited support.

690

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Japanese character is garbled when we run the queryKnowledge Drop

Last tested: Oct 18, 2020 The ProblemThere was an issue that the query which is filtered with Japanese character returned no result even though there is. We realized that Japanese character is garbled when we run the query with Japanese character as the following screenshot. Therefore none of the data matched with the filter value.Also, they set the global character set as "latin1" and created the database. This character set could be caused the character garbled issue.A SolutionNote: This is a solution which we solved with Amazon Aurora Database.Check the global character parameter set in RDS console. A.Check which parameter group is assigned to your database B.Check if the following five parameters are set to utf8mb4. If not, change them to utf8mb4. •character_set_client •character_set_connection •character_set_database •character_set_results •character_set_server C.Restart the RDS in order to reflect the new setting. Double check with the following command if the global character

690

1 year ago

molly.lippsettLooker Staff

published in Technical Tips & Tricks

How can I use an apostrophe in a user attribute value?Knowledge Drop

Last Tested: Jan 21, 2019Just put a \ before the apostrophe!ex. Default value: O\'Donnell This content is subject to limited support.

691

3 months ago

molly.lippsettLooker Staff

published in Technical Tips & Tricks

Replace commas in a list field with carriage returns using liquidKnowledge Drop

Last tested: May 26, 2020 Say you have a field that shows up like a, b, c but you want it to display in a single row asa b cYou can use a Liquid for loop with the split function to achieve this!html: {% assign items = your_dimension_here._value | split: ", " %}{% for item in items %}{{ item }}{% endfor %} This content is subject to limited support.

690

1 year ago

Department of Customer LoveModerator

published in Blog Archives

Speed up your data analysis with augmented analytics by Sisu + Looker

This content, written by Berit Hoffmann, was initially posted in Looker Blog on Oct 9, 2020. The content is subject to limited support.Today, everyone needs the ability to make data-driven decisions quickly. To meet this increased demand for data accessibility, organizations are breaking down barriers to insights by using platforms like Looker to embed dashboards into their teams’ existing workflows. With the level of data granularity and access users can achieve with Looker, it makes sense that the number of questions like “why is my KPI going up (or down) this week?” will increase. Herein lies the challenge. Even with a healthy data model, answering why-questions can require hours of manual work in the data. By the time all the necessary work is done and the data is examined to answer the initial question, new data has already been created — thus resulting in an incomplete answer. Fortunately, teams can bridge this gap between data questions and answers by combining the technologies

690

8 months ago

Department of Customer LoveModerator

published in Blog Archives

BigQuery Standard SQL + Looker

This content, written by Lloyd Tabb and Erin Franz, was initially posted in Looker Blog on Sep 28, 2016. The content is subject to limited support., we were excited to announce our support for Google BigQuery. At Looker, we love learning about advancements in database technology because our architecture fundamentally depends on it. The more flexible and powerful databases become, the more flexible and powerful Looker is. We were particularly psyched to explore BigQuery because it’s been powering Google’s internal data culture for more than a decade. When Google introduced BigQuery to the public, the first thing that grabbed us was its unique multi-tenant setup, which means that your database essentially never runs out of storage and never gets slow. This is ideal for Looker, as our LookML modeling language is dependent on querying data sources directly. Another key tenet of Looker’s philosophy is making data available to everyone in an organization, allowing everyone to be their own an

690

8 months ago

Department of Customer LoveModerator

published in Blog Archives

Using data to personalize culinary experiences for customers at Blue Apron

This content, written by Pooja Bathia, was initially posted in Looker Blog on Aug 13, 2020. The content is subject to limited support.Have you ever wondered how Blue Apron manages to deliver millions of “moveable feasts” — delicious, healthy meal kits, complete with step-by-step recipes and ingredients — to customers across the country every week? For several years, Blue Apron has leveraged the to power organization-wide access to data. You can learn more about the details of our migration to BigQuery and about our tech stack and implementation outlined in our with Google Cloud. Recently, the Google Cloud teams reached out to ask us about the new ways we’re leveraging data to efficiently serve and respond to our customer preferences, as well as hear some of the tips and tricks we’ve learned over the years. You can read below and watch this to learn about some of the newest, innovative ways I’ve had the pleasure of witnessing our Blue Apron teams leverage data to enhance our custome

690

8 months ago

srinija.godavarthiLooker Staff

published in Technical Tips & Tricks

Startup script scheduler flagsKnowledge Drop

Last tested: Jun 18, 2019 Changing --scheduler-threads=<i> is a good idea if you would like to limit the amount of schedules that are processed at one time, and the rest would be queued up. So if you just want to decrease the amount that would execute at one time down from 3 (default threads) that would be a good way to change that.As of version 6.18, the unlimited pool is set separately from the above via the --unlimited-scheduler-threads=<i> flag. In previous versions --unlimited-scheduler-threads was ignored and the pool was set to the same number of threads as --scheduler-threadsscheduler-query-limit=<i> flag (default: 10) : If a dashboard that has 20 tiles on it is scheduled, 10 would be queued.*Note that this limit is PER node, so in the first flags case, if there are 10 nodes, then there would be 30 threads available, etc. This content is subject to limited support.

680

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can I access, develop or extend the System Activity model?Knowledge Drop

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.

681

1 year ago

Peggy_BeardMember

published in Technical Tips & Tricks

Why won't a lookML error go away?Knowledge Drop

Last tested: May 22, 2018 A user may correct a lookML error or warning, re-validate, and the error just won't clear. In some cases it is referencing a field which can't even be found in the project. For example, you had a typo, found it when doing a validation check, corrected the typo, but the validation error or warning still won't clear.Some things to try are toggling dev mode on and off, and doing a hard refresh on the browser. If the changes have been pushed to production, another user can try the validation.Note that The LookML Validator scans only LookML files that have been updated since the last LookML validation, or files that are affected by updates, for more reference check our docs about Validating your LookML This content is subject to limited support.

680

1 year ago

mandy.chanLooker Staff

asked in Technical Tips & Tricks

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 allowlisting 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 year ago

samLooker Staff

published in Technical Tips & Tricks

Why am I seeing multiples of the same query running simultaneously?Knowledge Drop

Last tested: May 11, 2020 If you run a query, and then run a query with identical SQL, then Looker pulls the results from cache.If you run two queries at the same time with identical SQL, Looker realizes this and consolidates them into one request to your database. You may notice both queries appear to be "running" in the Looker UI but only one will hit the database.One common example is if you have the same query on a dashboard but with different visualization types. This content is subject to limited support.

680

1 year ago

molly.lippsettLooker Staff

published in Technical Tips & Tricks

Does changing the default color palette change visualizations colors?Knowledge Drop

Last tested: Aug 24, 2020 Yes! But if you tweaked any part of the color palette, the vis no longer is attached to the default palette, so those custom colors will stay. This content is subject to limited support.

680

1 year ago

shivanisankarNew Member

published in Technical Tips & Tricks

Why are my week dimension rows duplicating when I have the month dimension selected?Knowledge Drop

Last tested; Feb 1, 2021 You may notice that when you select the week dimension and some other fields, your data looks alright!However, when you add in your month dimension, some of your week rows are duplicating!Why is this happening? In this case, we can see 2020-12-28 getting repeated. This is because this week starts in the month 2021-012 and ends in 2021-01. There are two of the same week values, but they're getting correlated to two different months, causing the duplication.How can we fix it? We can add in a table calculation to extract the month. This will correlate the week to the month it starts in. This content is subject to limited support.

680

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Boxplot error message: "Can only combine like series on a single axis."Knowledge Drop

Last tested: Jul 10, 2019 If you see the above error on a boxplot visualization, change the chart type to line and go to Edit Visualization -> Y. We shouldn't have extra Y-axis in the line visualization configuration. Boxplots can only have a single Y-axis value. The boxplot inherits the config we had on the line visualization.Also, check if the Y-axis is showing the 5 measures or "stacked" - it needs to be the 5 measures you want to check. This content is subject to limited support.

670

1 year ago

mandy.chanLooker Staff

published in Technical Tips & Tricks

Stable PDT name not showing up with publish_as_db_viewKnowledge Drop

Last tested: Mar 23, 2020 Did you add the publish_as_db_view parameter after the table has been built and pushed to production?If so, the stable name will not show up.It'll only show up once the table has been rebuilt, so setting the publish_as_db_view_parameter as yes is not enough. You will either have to make a change to the sql code to get the regenerator to rebuild table or hit the Rebuilt Derived Table and Run button in the Explore.Creating the PDT with publish_as_db_view for the first time will allow for the stable view, but adding the publish_as_db_view onto a PDT that is already built won’t until the next rebuilt. This content is subject to limited support.

670

1 year ago

samLooker Staff

published in Technical Tips & Tricks

Why are Look/Dashboard IDs null in System Activity History explore?Knowledge Drop

Last tested: Apr 17, 2018 Probably because the query isn't tied to a Look or a dashboard, for example if the query was run from an explore page.There are some cases where look/dashboard ids won't show up even if the query is from a look or dashboard. API queries from looks and dashboards will show up with Source = API 3.0 and will not have a look or dashboard id. Scheduled job queries will show up with two entries in the history table, one with Source = Scheduled Task and one with Source = Saved Look, but neither one will show the look id. This content is subject to limited support.

670

1 year ago

Page 49 / 85

Badges

sbrylowskihas earned the badge Friendly Face
carriehas earned the badge Helpful
carriehas earned the badge Community Star
carriehas earned the badge Friendly Face
Dawidhas earned the badge Community Star

Show all badges

Sign up

Already have an account? Login

Social Login

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the Terms of Service.

If you’re an EEA-based consumer of digital content, services, or goods, and you’ve agreed to our Terms of Service, then EEA consumer laws provide you with a legal guarantee. Under this guarantee, we’re liable for any lack of conformity that you discover for the one-time supply of digital content or services at any time during the “continuous” supply of digital content or services.
Your national laws may provide an even longer guarantee. Your rights under these legal guarantees aren’t limited by any other commercial guarantees that we provide. If you want to make a guarantee claim or if you would like to delete your account data, please contact us lookerconnect-help@google.com.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

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.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

The Kitchen Table

Get the second max value with table calcKnowledge Drop

Is it better to use the running_total measure or to use Table Calculations to perform a running_total?Knowledge Drop

Types of AlertsKnowledge Drop

There must be at least 750 MB of free space in the temp directoryKnowledge Drop

Render error: Page not loaded within 300000 msKnowledge Drop

"Variable not found" error in liquid htmlKnowledge Drop

How do I count the number of models or views in a project?Knowledge Drop

Render job error: `query failed: Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.`

What happens when a null is concatenated with a value?Knowledge Drop

Japanese character is garbled when we run the queryKnowledge Drop

How can I use an apostrophe in a user attribute value?Knowledge Drop

Replace commas in a list field with carriage returns using liquidKnowledge Drop

Speed up your data analysis with augmented analytics by Sisu + Looker

BigQuery Standard SQL + Looker

Using data to personalize culinary experiences for customers at Blue Apron

Startup script scheduler flagsKnowledge Drop

Can I access, develop or extend the System Activity model?Knowledge Drop

Why won't a lookML error go away?Knowledge Drop

Why is it necessary to domain whitelist when user attributes values are set to hidden?

Why am I seeing multiples of the same query running simultaneously?Knowledge Drop

Does changing the default color palette change visualizations colors?Knowledge Drop

Why are my week dimension rows duplicating when I have the month dimension selected?Knowledge Drop

Boxplot error message: "Can only combine like series on a single axis."Knowledge Drop

Stable PDT name not showing up with publish_as_db_viewKnowledge Drop

Why are Look/Dashboard IDs null in System Activity History explore?Knowledge Drop

Badges

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded