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 views

Recently active Most replies Newest first

Article Why don’t my table calculations have totals?

Last Tested: Feb 14, 2019As of version 6.2, there are now Totals on Table Calcs in most situations. Note that not all table calcs have totals and also note that some table calc totals may show as incorrect or "unexpected". This goes back to the overarching discussion of Totals are not Totals.Prior t...

Technical Tips & Tricks

Article Rank across pivots with table calculations

Last tested: Sep 29, 2019 We are able to create Rank across pivots with a number of table calculations.Assuming that we have two dimensions, brand and status, and one measure, let's call it count. We created an explore, in which we have the dimension brand, we pivot on status and have the measure co...

Technical Tips & Tricks

Article How do I make OR filters when using Filters on Measures?

Last Tested: Sep 6, 2019 This is outlined in a Help Center article. For a single field with multiple values, you can put them all into the filter string:measure: count_field {type: countsql: ${TABLE}.total_orders ;;filters: {field: ordersvalue: "1, 4, null"}} Where we end up filtering WHERE orders =...

Technical Tips & Tricks

Article Max Custom Row Limit for Download from the UI

Last tested: Jan 22, 2019 If All Results is unavailable for a query, users can still select the Custom Limits option with a limit of up to 100,000 rows. If you know that your instance has been provisioned to be able to export more than 100,000 rows of unstreamed results, you can further increase tha...

Technical Tips & Tricks

Article Expected \"(\" or keyword SELECT but got keyword WITH at

Last tested: Jan 17, 2019 This is one example of an error you can get by using a CTE in a derived table. See this article for more info: Can you use CTEs (WITH syntax) in a PDT? (common table expressions, aka WITH param). This content is subject to limited support.

Technical Tips & Tricks

Article Advanced LookML - Intro Aggregate Awareness

Last tested: Jun 24, 2019 This is a useful method if you have summary tables defined in your ETL process. Otherwise, take a look at our Aggregate Awareness documentation to see if our native option works for you!Aggregate awareness is a BI term that describes the ability to use aggregate (summary) t...

Technical Tips & Tricks

Article Using liquid to create a custom date range

Last tested: Jan 27, 2021 This works if a user would like to be able to select a date, and then a number of days they'd like to see before and after the selected date. For example, if I selected 10 and Mar. 14, the resulting date range would be Mar. 10 - Mar. 24.Here's the lookml:parameter: number_o...

Technical Tips & Tricks

Article How do Filter Suggestions Work?

Last tested: Aug 21, 2020 Filter suggestions are a way to save time when typing into filters and ensure you're choosing an option that exists in the data. When you click into a filter box, a list of suggestions will appear below the field. Where does this list of suggestions come from?Looker will ru...

Technical Tips & Tricks

Article Can you save explores created from sql runner as a look or to a dashboard?

Last tested: Aug 9, 2019 It is not possible to do that in Looker at the moment. You can vote for a feature request here: Save a sql runner explore as a look or add to a dashboard.However, if the look is only accessible by Admins, you can use this workaround (remember, ONLY Admins, other users will g...

Technical Tips & Tricks

Article There was a problem running the query

Last Tested: Oct 8, 2019This is a super generic error so you'll need to do more digging. However, these questions should get you started in determining why this is happening.if you haven't already done so, confirm where you are seeing this error. We've had it reported from Explore pages and Merged R...

Technical Tips & Tricks

Article Dynamic Reference Lines with Value Labels

Last tested: Sep 20, 2019 The ProblemSome users want reference lines in their visualization that use metrics that are not in our standard drop-down options. They could always use a custom value, but that value is static, so if it is based on a calculation of the data, it doesn't quite suit their nee...

Technical Tips & Tricks

Article Where can I submit a feature request?

Please refer to this community post which describes our new Pendo feedback process. You can now see a link in the help dropdown in Looker that says “Product Idea?”. Click that link and you’ll be taken to their request dashboard. From there, you can see what’s coming, what others have suggested, and...

Common Account Questions

Article What to model in-database (or in-ETL) versus in LookML

Last tested: Jun 1, 2020 This article: How do you decide what to model in dbt vs LookML? gives an outline. Substitute dbt for any other ETL or database-layer transformation tool. The key points are that LookML is best for modeling query-time transformations in an iterative way. LookML is best for Qu...

Technical Tips & Tricks

Article What is a cURL API call, and what does it look like?

Last tested: Nov 4, 2020 cURL is a command-line utility available on most Unix/Linux based operating systems which can be used to make an HTTP network request and receive the response either interactively as you type or in a bash shell script. cURL can make any kind of HTTP requests, configure reque...

Technical Tips & Tricks

Article Variable not found "parameter"

Last Tested: Sep 6, 2019 ProblemThis error usually indicates that the {% parameter parameter name %} liquid variable is being used somewhere where it's not accepted.SolutionSince the _parameter_value variable is accepted in more places than parameter parameter name (notably the html, link, and sql_a...

Technical Tips & Tricks

Article How do I Referencing a Dimension from Another View in Drill Fields?

Last Tested: May 13, 2020 You can use the view_name.field_name syntax to reference a field from another view in drill fields.drill_fields: [field1, view2.field2] This content is subject to limited support.

Technical Tips & Tricks

Article BIGQUERY (HowTo): How do you escape a table or field name in BigQuery?

Last tested: Jan 10, 2018 In BQ Standard SQL, you can escape names by enclosing it in backticks:SELECT `schema.table`.`field` AS table1.field FROM public.`schema.table` AS table1 In BQ Legacy SQL, you can escape names by enclosing it in brackets:SELECT [schema.table.field] AS table1.field FROM [proj...

Technical Tips & Tricks

Article Error: Your account has been temporarily locked due to too many bad login attempts

Last tested: April 2021 This error comes up if you try and log in with a bad password too many times.You only have to wait 5 minutes for it to unlock. This is non-negotiable, however you can instead use SAML/LDAP which may have providers that allow you to change these settings.Docs: https://docs.loo...

Technical Tips & Tricks

Article What is Unit Testing/ Data Validator/ Data Tests/Results Validator?

Last Tested: Sep 24, 2019 All three of these names refer to the same feature, which is called “data tests” (formerly referred to as unit testing). This is a feature released as part of Looker 6, generally available on version 6.20.This is essentially Unit testing for LookML, where you write a query,...

Technical Tips & Tricks

Article API Call Timeouts

Last tested: Nov 5, 2020 If you are using an SDK and you're hitting timeout errors on your calls, you should be able to adjust the timeout parameter on your call.For example, with the Python SDK if you are running run_inline_query(), you should be able to format it in this manner:run_inline_query({s...

Technical Tips & Tricks

Article How do I put line breaks for a long URL or other string in LookML without interrupting the string?

Last tested: Sep 6, 2019 Use the {% comment %} tag:dimension: test_link {sql: '1' ;;link: {label: "test google with line break"url:"https://google{% comment %}{% endcomment %}.{% comment %}{% endcomment %}com"}}Note that line breaks just add %20 into the URL so this would only be necessary if that w...

Technical Tips & Tricks

Article What are Query Slugs?

Last tested: Mar 26, 2020 We currently have 3 kinds of queries: Normal Queries, SQL Runner Queries, and Merge Queries. Information about each resides in its own table in the internal database (normal queries in the query table, sql runner queries in the sql_query table, merge queries in merge_query...

Technical Tips & Tricks

Article Why can't I "hide no's from visualization" in a table calc?

Last tested: Sep 11, 2019 Double check to see if the Yes and No values have quotes wrapped around them!Note that if(${field_name} > x, "Yes", "No") is not the same as if(${field_name} > x, yes, no). If we include quotes around the yes and no values, Looker will output strings and we'll lose th...

Technical Tips & Tricks

Article How do I get the last n characters of a string in table calculations?

Last tested: Sep 19, 2017 You can take a substring from the end of a string by using the length function to calculate the starting point. Let n be the number of characters at the end you want to get:substring(${field_name}, length(${field_name}) - (n-1), n) If I want to get the last 4 digits of the...

Technical Tips & Tricks

Creating a pie chart with over 50 rows using table calcs to create an "Other" bucket

It is sometimes the case that we need to create a pie chart, or any other chart that has row limits, but our raw data exceeds those limits.We can always make Lookml or SQL Database changes to create buckets, such as seen here:but that doesn’t always match our work flow.My solution is an explore-only...

Technical Tips & Tricks

1
...
3
4
5
6
7
8
9
...
68

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