Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started113 News & announcements112 Who's hiring413 Release notes (archive)63 Lesson Comments12 Challenge10
Looker developmentLookML1559 SQL284
Exploring & curating dataExplores490 Dashboards & looks1353
Application developmentEmbedding Looker / Powered by Looker132 Open source projects47 Looker API331
AdministrationUser access & management51 General Looker administration413
Data science & analyticsGot a question?69 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 Referencing the Quarter Timeframe in table calcs

Last tested: Jun 25, 2020 Say you're using a quarter timeframe that results in 2020-Q2, for example. If you were to create a table calculation referencing this, sayif(to_string(${quarter_field}) = "2020-Q2", ${arbitrary_field}, null)You would never satisfy the Yes condition of the if() statement. Th...

Technical Tips & Tricks

Article How do I get a list of dashboards that a user has access to via the API?

Last tested: Dec 28, 2017 First, you will want to pull down the content_metadata_id and id fields from every dashboard using the all_dashboards endpoint. We don't need the other fields, so limiting to just those two helps save some time.Be sure to grab the dashboard folder's content_metadata_id, rat...

Technical Tips & Tricks

Article System Activity History: Result source is "stale_cache"

Last tested: May 28, 2020 If the value for the History table's Result Source field is "stale_cache", this can be the result of an instant dashboard. When instant dashboards are turned on, the results can return from a cache that has expired (aka "stale" cache).The dashboard should rerun when this ha...

Technical Tips & Tricks

Article Can we define a view: parameter within a Model file? An explore: within a View file?

Last tested: Jun 28, 2021 This is technically possible, but we recommend against it, mainly for readability and organizational purposes. There are very few instances where it would be recommended/preferable to do this.You can technically define any object you want inside any file. The LookML parser...

Technical Tips & Tricks

Article Can I see user event activity in system activity? For example, seeing which users committed code?

Last tested: May 13, 2020 Yes, we have the /event and /event_attribute explores in system activity. Those explores will have Event Category and Event Names. The event_attribute explore has more robust information on the details of things that were changed.A few example Event Names are below:create_p...

Technical Tips & Tricks

Article ${TABLE} is not allowed in the 'X' property.

Last tested: Aug 29, 2019 If you get an e-mail with a schedule error and it says ${TABLE} is not allowed in the 'X' property, this because you are using ${TABLE} outside of a sql parameter.Example of where this would fail:dimension: test {type: stringsql: ${TABLE}.field ;;# The below html references...

Technical Tips & Tricks

Article Is there a way to get rid of the "Row limit reached" message, when we drill down in the explore?

Last tested: Jun 28, 2021 Not at the moment, but you can share your request with the Product team via Pendo! This content is subject to limited support.

Technical Tips & Tricks

Article What could cause the purple loading bar to get stuck?

Last tested: Apr 24, 2020 This is probably either due to an intermittent outage on the load balancer, or because an incomplete Javascript chunk has been cached on the browser.The only network requests that are sent while that loading bar is animating are for fetching the JS code that's responsible f...

Technical Tips & Tricks

Article 500 Error on Add To Project

Last tested: Apr 2, 2020 Problem: Receiving the error: "Uh Oh! Something went wrong. 500" when selecting "Add to project" from SQL Runner, in order to add a query straight to a derived table view.Console Error: Failed to load resource: the server responded with a status of 500 (Internal Server Error...

Technical Tips & Tricks

Article AssertionError in SDK call

Last tested: Apr 30, 2020 Users of the SDK have seen this error in the past when using a dictionary syntax rather that using the WriteUser type in the bodyEx. GOODimport looker_sdkfrom looker_sdk import modelsnew_friend = sdk.update_user(user_id=#, body=models.WriteUser(first_name="first_name_test",...

Technical Tips & Tricks

Article How to Handle \n in dimensions - Newline_to_br Liquid

Last tested: Oct 24, 2019 Liquid Reference for newlinedimension: variable {type: stringsql: ${TABLE}.variable ;;html: {{ variable | newline_to_br }} ;;} This content is subject to limited support.

Technical Tips & Tricks

Article Can I enable SAML on my instance?

Looking to create some added/different security to your Looker instance via SAML? Looker is well equipped for that, and multiple customers have enabled this for peace of mind, to fit their use case, or various other reasons! Have a look at this intuitive doc, on how to get started, the setup needed,...

Common Account Questions

Article Troubleshooting Slack action errors

Last tested: Jul 28, 2020 You may see one of the following error messages when setting up and testing the Slack action in the Action Hub:Error: An error occurred for action looker-integration://1::slack_app. The action could not be executed.There may be a temporary issue with Looker instance=https:/...

Technical Tips & Tricks

Article Why do my queries with table calcs have such a long post-process/unaccounted for time when downloading?

Last tested: Jun 24, 2020 There could be a few reasons for this, first off table calcs operate over the entire result set. So say one of the calcs makes a list out of the column, that is a 5000 entry list in the simplest case, 50000 in the 20+ minute case. If you then try to take the maxof that, one...

Technical Tips & Tricks

Article Filtering on Last Business day of Month

Last tested: Feb 2, 2021 dimension: returned_last_business_day {type: yesnosql: CASE WHEN EXTRACT( day from DATEADD(day,2,${returned_date_raw}) ) = 1 AND ${returned_day_of_week} = "Friday"THEN trueWHEN EXTRACT( day from DATEADD(day,3,${returned_date_raw}) ) = 1 AND ${returned_day_of_week} = "Friday...

Technical Tips & Tricks

Article What does the Ordinal Scale Type visualization setting do?

Last tested; Jan 13, 2021 The short explanation is that with Ordinal Scale Type setting, data is plotted along the x-axis as evenly-spaced, discrete entries, regardless of relative distance between data points. (https://docs.looker.com/exploring-data/visualizing-query-results/column-options#scale_ty...

Technical Tips & Tricks

Article SQL Error: relation "schema.table" does not exist"

Last tested: Feb 2021 This error message can appear when a table no longer exists but still shows in the list of tables for this schema.Error Message Error Running SQL ERROR: relation "schema.table" does not existTroubleshooting Go to the gear option next to the connection name and hit "Refresh Tabl...

Technical Tips & Tricks

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

Technical Tips & Tricks

Article Custom filter: filter the last day of each month/quarter until yesterday

Last tested: Sep 3, 2020 Some users might have cumulative data ( such as running total partition by month/quarter ) on monthly or quarterly basis, and usually it's quite hard to query the sum of each month/quarter because there's no existing filter option to filter the last day of each month/quarter...

Technical Tips & Tricks

Article How to bulk delete projects in all users model folders

Last tested: Mar 15, 2021 Occasionally you may want to delete a project that’s no longer in use and find that you can’t from the UI. If your instance is Looker-hosted, you can request support to delete that project from the production and development for all the users. Make sure you have technical c...

Technical Tips & Tricks

Article How to filter complete weeks in the last quarter

Last tested; Jan 3, 2020 For some analysis, you might want to get only the completed weeks in the last quarter, for example, if the first day of Q4 2019 (2019-10-01) is Tuesday, then the start day should be 2019-09-30, and the last day of the quarter is 2019-12-29 (Sunday).We can use the below SQL t...

Technical Tips & Tricks

Article Can slack actionhub and Lookerbot use the same bot user?

Last tested: Jan 15, 2019 Yes. Lookerbot is also an action hub. This content is subject to limited support.

Technical Tips & Tricks

Article Table calculation for time difference accounting for negatives

Last tested: June 15, 2020 The general logic here is, if the time diff is negative, then build own results using diff_minutes/diff_seconds, otherwise; do the calculation.if(${history.created_time}<${history.completed_time},concat("-",ceiling(diff_minutes(${history.created_time},${history.complete...

Technical Tips & Tricks

Article Error "The resource already exists" while using create_dashboard endpoint

Last tested: Nov 9, 2020Check if you're passing a slug in to the call - each slug needs to be unique system wide, so that's a possible cause for this error. This content is subject to limited support.

Technical Tips & Tricks

Article Table calculation for time difference accounting for negatives

Last tested: Jun 1, 2020 The general logic here is, if the time diff is negative, then build own results using diff_minutes/diff_seconds, otherwise; do the calculation.if(${history.created_time}<${history.completed_time},concat("-",ceiling(diff_minutes(${history.created_time},${history.completed_...

Technical Tips & Tricks

1
...
48
49
50
51
52
53
54
...
68

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