Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started153 News & announcements128 Who's hiring443 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1890 SQL327
Exploring & curating dataExplores579 Dashboards & looks1624
Application developmentEmbedding Looker / Powered by Looker162 Open source projects56 Looker API388
AdministrationUser access & management77 General Looker administration464
Data science & analyticsGot a question?87 Share your best practices16
The Kitchen TableTechnical Tips & Tricks1741 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥4
コミュニティフォーラム (Japanese)ニュースと告知51 ヘルプとサポート14 コラム69

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2111 Topics

Most replies

Recently active Most views Newest first

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.

540

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

How to scale labeling for quantitative data on the X-axis of a visualizationKnowledge Drop

Last tested: Jan 2, 2020 The ProblemSomeone sends you the following screenshot from a dashboard tile or a visualization from an explore, and wants to know why not all months are being represented on the X-axis.A SolutionBy default, the displayed points on both axes of the chart scale with the size of the window. The following screenshot is the same visualization as above, automatically scaled to display in a smaller window.How would one change this to force all data points on the X-axis to be represented properly?In the visualization in the explore (i.e. if you are troubleshooting a dashboard tile, navigate to the underlying visualization), click the gear icon at the top right hand corner of the pane. Scroll over to 'X', and change the 'Scale Type' to 'Ordinal'. Note that this can be accomplished through LookML.A CaveatNote that even when the scale type is set to ordinal, there will be times when not every data point will be shown on the X-axis due to space limitations: This co

2550

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can you restore a folder after you delete it?Knowledge Drop

Last tested: Oct 2, 2019 Not directly but you can get back to the old state with some work. We warn you and ask you to type the name of the folder in order to delete it for this reasonWhat you can do:The folder is now gone, so first create a new one. All the content will now be in the trash with the exact same deleted time. If you literally just deleted the space and want to restore it immediately you may be able to tell what content needs to go back just from looking at the trash (need to be an admin to see the Trash btw) If you aren't sure which content needs to be recovered simply by looking you can use the spaces explore ( expanded system activity url: /explore/system__activity/space?fields=space.name,space.deleted_time,space.id&sorts=space.deleted_time+desc&limit=500&vis=%7B%7D&filter_config=%7B%7D&origin=share-expanded) to find the timestamp the folder was deleted at. find dashboards with this deleted timestamp (expanded system activity url: /explore/system__

2720

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Table Calculation to Grab Value(s) Associated with Last Pivoted ColumnKnowledge Drop

Last tested: May 27, 2020 TL;DR: index(pivot_row(pivot_column()), max(pivot_row(pivot_column()))) returns the index number of the last pivot columnSometimes a user might have pivoted on a timeframe or date field and as such, the final pivoted column will be the most recent date with whatever associated data they want to show. This was necessary because their column chart visualization required them to pivot on their date field instead of having it as a primary dimension. And in this case, they only wanted to display the most recent data associated with the final pivoted column in the pivot 'series'.At first...I thought max(pivot_column()) would work..but no....it evaluates within each pivoted column, not across the whole pivoted 'series'...So, first, we can grab the pivot col # of the last pivoted column with this:index(pivot_row(pivot_column()), max(pivot_row(pivot_column())))This ^ is really just creating a list of pivot #'s (i.e. if you have 5 pivot columns then -> 1,2,3,4,5), th

2910

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can we reference a yesno dimension in a condition statement using liquid?Knowledge Drop

Last tested: Apr 10, 2020 Nope, we'll need to use a parameter if we want to add user inputs to a conditional statementScenario:We have a yesno dimension that users are filtering on. We want to be able to pull in that value that users select to display a measure based off the condition.LookML Definition:Explore View (What users see): Generated SQL:Ideal Outcome:Based off the set up, ideally what would happen here is if our user changes the filter to "No" then we'll display 2 in the measure. However, what we'll see is if we update the "Yes/No" filter to "No", it will add it to the WHERE clause and the SELECT statement defined in the measure will remain the same. (Therefore justifies that the yes/no condition isn't being checked)Why it doesn't work:In order for Looker to grab the user selected Filter value, we need to run the query in order to know what the user select (yes or no). However, there's no mechanism within Looker to run the query to grab that value, then input the selection in

1710

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Error: Not authorized to run scheduled planKnowledge Drop

Last tested: May 25, 2020 This error may come up in existing schedules that "worked" fine due to scheduling permissions changing from instance wide to model specific in 6.24.The biggest post 6.24 change is that yeah, for system_activity the schedule owner has to be an admin because schedule content is on the model level and system activity cannot be added on a model set level. This content is subject to limited support.

840

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Troubleshooting Enabling FoldersKnowledge Drop

Last tested: Nov 27, 2019 If you want to enable folders for your Projects and have a large number of varying lookml files, take the following precautions before you get started.Have all developers check in all changes before anyone enables folders. Identify any files that are using NDTs and flag them as files that need the include statement to be updated. Identify any model files that have include statements. These will need to be translate to the new include syntax post-migration. Check to make sure that connections that do not have PDTs enabled do not have include: /../*.view as this can cause lookml errors. After checking the enable folders box in your project, make sure that no one else is make commits/pushes anywhere else in the project until you have deployed the new folder structure changes. This can blocks commits that prevents you from resolving merge conflicts. If you encounter the issue from #4, revert all uncommitted changes, pull, and push immediately. Fix any issues afte

130

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Is it possible to open Product Ideas? in a new tab/window from Looker?Knowledge Drop

Last tested: Aug 31, 2020 At this time NO - the Pendo team looked into this but it's a bit difficult because of how the access token behavesThe workaround/workflow would be to open Looker in another tab to then access Product ideas This content is subject to limited support.

220

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can I use the `value` liquid variable in sql parameters?Knowledge Drop

Last tested: Jun 22, 2020 No. You can check the Usage column in the liquid variable reference in docs to see where each variable can be used.why not?The value and field_name._value variables take their values from the results of a query that have been returned from the database. Therefore, these variables can only be used in parameters that can be resolved after the query results have come back, such as the link, html, and action parameters. Since sql parameters determine the SQL for the query Looker generates, they must necessarily be resolved before the query is sent to the database and therefore before the query results come back. This content is subject to limited support.

770

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Looker specific reserved wordsKnowledge Drop

Last tested: May 27, 2020 Scenario:We run the LookML validator and see a this error:a dimension/measure named 'yes' or 'no' or a reserved keyword Reasoning:Reserved words are words that programs have explicitly state to have fixed meaning and can't be redefined. In this case, Looker has reserved the words yes and no, therefore when defining them as dimensions, you'll get this validation error. This content is subject to limited support.

190

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Expected \"(\" or keyword SELECT but got keyword WITH atKnowledge Drop

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.

9290

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Why are my API-accessed JSON objects returning numbers instead of strings?Knowledge Drop

Last tested: Oct 7, 2019There was a legacy feature that allowed JSON numbers to return as strings that was completely removed in 5.4. You can find information about how to solve this problem here: Deprecation Notice: JSON Numbers Can be Returned as Numbers Instead of Strings in API (3.52+). This content is subject to limited support.

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

What does a ChunkLoadError in the JS console mean?Knowledge Drop

Last tested: Mar 16, 2020 A "ChunkLoadError" generally means that a checksum failed for a javascript file.These errors occur when the browser requests a JS code chunk, and receives a response whose checksum does not match the expected “integrity=…” attribute associated with the <script> tag that refers to it.Normally this is caused by one of:1. Corporate proxy or Antivirus which does “man in the middle” SSL spoofing to do security scans, and falsely recognizing a pattern of bytes which looks like a malware signature2. Ad blocking software which matches a fragment of the filename as possible ad, and it truncates/omits the response3. An intervening cache (nginx, squid, apache, etc) has cached an empty or otherwise-modified version of the script chunk, perhaps while the Looker host was temporarily unavailable/rebooting.The names of these files generally change with each new release of Looker, so there is a fresh opportunity to encounter one of these problems before each browser succ

5250

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

What are mode=0 & mode=1 in active_derived_table?Knowledge Drop

Last tested: Nov 10, 2020 The mode column indicates the state of the derived table.mode=0 being inserted into active_derived_table indicates that a table needs building. 2020-09-10 00:35:53.872 +0000 [INFO|5f59582f04833e9887e4d4b663f993dd|db:looker] :: (0.000946s) INSERT INTO `active_derived_table` (`key`, `structure`, `dead_at`, `name`, `connection`, `mode`, `model`, `retired_at`, `full_view_name`) VALUES ('TH9V2WU3F8FXOODPMURFG_some_table', 'THEQ5ULC9Z5BC1VYH13EF_some_table', 0, 'LR$TH9V21599698153866_some_table', 'some_model', 0, '', 32503593600, 'some_table' mode=1 being inserted into active_derived_table indicates that a regen thread has picked up this table and begun building in (typically the entry for the mode=1 build claim will have a pdt log action of "create begin" & pdt log action data of "prod." 2020-09-10 00:35:53.892 +0000 [INFO|5f59582f04833e9887e4d4b663f993dd|db:looker] :: (0.000916s) INSERT INTO `active_derived_table` (`key`, `structure`, `name`, `connection`, `d

100

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Schedule to 2 SFTP Servers Via the APIKnowledge Drop

Last tested: Jan 20, 2020 You can send a single schedule to 2 SFTP servers using the API! In order to get this working, you must add an additional JSON dictionary object to the "scheduled_plan_destination" section of the JSON body like so: "scheduled_plan_destination": [{"id": 12804,"scheduled_plan_id": 5175,"format": "wysiwyg_pdf","apply_formatting": true,"apply_vis": true,"address": "sftp://myserver.com/files/","type": "sftp","parameters": "{\"username\":\"sftpuser\"}","secret_parameters": "{\"password\":\"mypassword/\"}","message": null,"looker_recipient": false},{"id": 12804,"scheduled_plan_id": 5175,"format": "wysiwyg_pdf","apply_formatting": true,"apply_vis": true,"address": "sftp://otherserver.com/file_path_sftp/","type": "sftp","parameters": "{\"username\":\"otheruser\"}","secret_parameters": "{\"password\":\"otherpassword/\"}","message": null,"looker_recipient": false}],In Looker SFTP we only allow username/password auth, and here in the JSON body the 'username' is included wi

210

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

550

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

PDT Logs: Consecutive Trigger ChecksKnowledge Drop

Last tested: Nov 2, 2020 If you happen to come across consecutive trigger datagroup check's equal to true for a given table in the pdt event logs and you have confirmed that the cron job shouldn't be causing this, this is likely because we fire off multiple trigger checks before the regenerator builds a PDT.The first trigger check is sent when the regenerator starts its run, the second when it gets around to actually building the table. Note that there will always be a trigger check of true before the regenerator begins building a pdt and as such the last true trigger check should indicate/match up with the time in which the create begin event is logged for the given PDT. This content is subject to limited support.

1 year ago

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

why can't looker read my topojson?Knowledge Drop

A Cure For Merged ResultsKnowledge Drop

What is errorsfallback@looker.com?Knowledge Drop

Setting up an access_filter that applies to only specific usersKnowledge Drop

Having Default Label Value that's Based off a ParameterKnowledge Drop

Hide Filters on Embedded DashboardKnowledge Drop

Can you edit a look's visualization settings using the API?Knowledge Drop

Error Starting LookerKnowledge Drop

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

How to scale labeling for quantitative data on the X-axis of a visualizationKnowledge Drop

Can you restore a folder after you delete it?Knowledge Drop

Table Calculation to Grab Value(s) Associated with Last Pivoted ColumnKnowledge Drop

Can we reference a yesno dimension in a condition statement using liquid?Knowledge Drop

Error: Not authorized to run scheduled planKnowledge Drop

Troubleshooting Enabling FoldersKnowledge Drop

Is it possible to open Product Ideas? in a new tab/window from Looker?Knowledge Drop

Can I use the `value` liquid variable in sql parameters?Knowledge Drop

Looker specific reserved wordsKnowledge Drop

Expected \"(\" or keyword SELECT but got keyword WITH atKnowledge Drop

Why are my API-accessed JSON objects returning numbers instead of strings?Knowledge Drop

What does a ChunkLoadError in the JS console mean?Knowledge Drop

What are mode=0 & mode=1 in active_derived_table?Knowledge Drop

Schedule to 2 SFTP Servers Via the APIKnowledge Drop

Japanese character is garbled when we run the queryKnowledge Drop

PDT Logs: Consecutive Trigger ChecksKnowledge Drop

Badges

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded