Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started114 News & announcements112 Who's hiring414 Release notes (archive)63 Lesson Comments13 Challenge10
Looker developmentLookML1565 SQL284
Exploring & curating dataExplores491 Dashboards & looks1356
Application developmentEmbedding Looker / Powered by Looker132 Open source projects48 Looker API331
AdministrationUser access & management52 General Looker administration415
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

Recently active

Most replies Most views Newest first

Article The PDT Regenerator Process

Last Tested: Nov 4, 2020 Purpose:The regenerator's purpose is to manage the building of PDTs on the scratch schema. Its major tasks are to check datagroup triggers, build new PDTs that have been pushed to production and rebuild existing production PDTs whose trigger values have changed.Number of Reg...

Technical Tips & Tricks

Article CSV downloads with foreign currency renders as Â£ in Excel ( Euros, British Pounds, etc.)

Last tested: Aug 17, 2019This is a bug in how excel handles CSV files. Try downloading the content as XSLX instead! This content is subject to limited support.

Technical Tips & Tricks

Article Why can't I see my explore in the Explore drop-down menu?

Last tested: Aug 31, 2020 First confirm that the Explore has been saved and then refresh the page to see if the explore is populating in the Explore dropdown.If the explore still isn't showing in the Explore menu, check if:The extension: required parameter is defined in the Explore. An Explore with ...

Technical Tips & Tricks

Article What HTML tags are allowed? (HTML Sanitization)

Last tested: March 2021 This doc lists all of the allowed HTML tags that can be used in html blocks in Looker. This content is subject to limited support.

Technical Tips & Tricks

Article Custom Filter for "Year to Date on Last Year to the same date Last Year"

Last tested: Jan 21, 2019In custom filters:((extract_years(now())=extract_years(${download_stats.timestamp_year})AND ${download_stats.timestamp_year} <= now())OR(((extract_years(now())-1)=extract_years(${download_stats.timestamp_year})AND ${download_stats.timestamp_year} <= add_years(-1,now())...

Technical Tips & Tricks

Article How can I reverse a running total so that it goes from bottom up?

Last tested: Jan 21, 2019 Running Total Down:sum(offset_list(${measure},1-row(), row()))Running Total Up:sum(offset_list(${measure},0,count(${dimension})-row()+1)) This content is subject to limited support.

Technical Tips & Tricks

Article What happens when an embed user connects to looker but the user already exists as a regular user in looker?

Last tested: Sep 2020 In this case a new embedded user would be created. There is no way to tie an embed user created from a script to a regular user. For any embedded user that gets created, the primary key/identifier is the external_user_id field that gets passed in.Since the embed user will be...

Technical Tips & Tricks

Article How do I change the order of my visualization/table?

Last tested: Dec 19, 2019 Table NextIn Table Next, you can freely drag columns around in the visualization.Table LegacyIn Table Legacy, the order of the visualization is dependent on the order of the columns in the data table. You can drag the columns to change the order of the series. However, you...

Technical Tips & Tricks

Article How to sync a LookML Dashboards with a UDD Dashboards using the API

Last tested: Aug 26, 2019 You may find yourself in a situation where you want to make changes to a User Defined Dashboard, and have those changes be reflected in an existing LookML Dashboard. This is possible via the API:dashboard() Insert the UDD id and run Copy the Response Body update_dashboard...

Technical Tips & Tricks

Article How to Create a running average/sum/count for a specific interval using table calculations?

Last tested: Apr 4, 2020 If a user wants the trailing average/sum/count for the last n days, usually this can be done with a subquery, but you can also visualize it using table calculations.Underlying Data: First we create a table calculation using the modulus function to get the correct date interv...

Technical Tips & Tricks

Article Error starting Looker. See log file for details.

Last tested: Nov 17, 2017 Chat tip: In general, try stopping looker then check if the java process is running. If it is, kill it and try again.Search the log file for ERROR. Below are some errors and the ways to fix them (at the time of this writing there is just one that I know of)Error starting Lo...

Technical Tips & Tricks

Article How can I enter multiple filters into Parameters?

Last tested: May 2020 Parameters only accept a single value.In the event that you have a comma separated list like a,b,c in your filter, the parameter syntax {% parameter filter_field %} will bring that in as a single string "a,b,c" .Therefore, if you have multiple values, use templated filters inst...

Technical Tips & Tricks

Article Content Validator Quick Facts

Last tested: May 2020 The content validator checks to see which of your Looks and dashboard tiles are broken by LookML changes.DOES Replace models, explores, views, fields, fields used in table calculations and custom fields Remove models, explores, views and fields Check lookless tiles (Looker...

Technical Tips & Tricks

Article Can you manually assign a role to a user that is not determined by the [SAML/LDAP] Group to Role mapping?

Last tested: Jan 2019 No. Roles will be overwritten for a user any time that user logs in with [SAML/LDAP]. So while it's technically possible to manually assign some roles while the user is currently logged in, those changes will be wiped each time the user logs in. This content is subject to limi...

Technical Tips & Tricks

Article Track Downloads in System Activity (workaround)

Last tested: Nov 26, 2020 It's currently not possible to track download events in i__looker / System Activity. Be sure to give a +1 to the request: https://portal.feedback.us.pendo.io/app/#/case/17696Workaround: You'll need to piece together different explore results so it's admittedly not as straig...

Technical Tips & Tricks

Article PDT trigger value at a specific time and day of week, once a week

Last Tested: Mar 22, 2021 This trigger changes weekly at 6 am on Monday:MSSQL: SELECT FLOOR((DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) - 60*60*(24*4 + 6))/(60*60*24*7))Postgres: SELECT FLOOR((EXTRACT(epoch from NOW()) - 60*60*(24*4 + 6))/(60*60*24*7))Redshift: SELECT FLOOR((EXTRACT(epoch from...

Technical Tips & Tricks

Article Custom Order for Field Picker

Last tested: Dec 14, 2018 By default, the Field Picker is sorted alphabetically.Workaround: If you add spaces to the label of a dimension, then you can change where it will appear in the field picker. Additionally, the leading spaces are stripped from the UI, so it won't look ugly to your consumers....

Technical Tips & Tricks

Article Can you auto-generate a model file in an existing project?

Last tested: May 2020 No.When you first make a project, you are prompted to generate LookML for it based on a database connection. You won't get this option a second time, mostly because we assume you've made changes to the model file since then.You can, however, create a new view from a database ta...

Technical Tips & Tricks

Article Create Day of Quarter in Table Calc

Last tested: Jun 15, 2021 This requires 3 easy steps of Table Calc magic.Here is a picture to get an idea.The steps are belowCreate an extract months table calcextract_months(${table.date}) Create an extract days table calcextract_days(${table.date}) Create Days of Quarter, referencing the month and...

Technical Tips & Tricks

Article Dashboard doesn't look the same on a different screen

Last tested: Sep 10, 2020 The columns on my dashboard are alined on my screen, but not on my colleagues.I've had a couple customers come on chat to report a 'bug' that their dashboard doesn't look the same on their colleagues screen. Column headers are clipping, misaligned across tiles of the same w...

Technical Tips & Tricks

Article Why is my measure of type:count being made into a COUNT DISTINCT in the SQL?

Last tested: May 2020 A count measure usually creates a COUNT(*) in the SQL. However, if joins are involved, then a COUNT(*) would cause a fanout.So to avoid this, Looker generates a COUNT DISTINCT on the view's primary key instead. This should give you the same results as a COUNT(*) on that table w...

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 Filter on this month but also see previous month's data

Last tested: May 2020 The ProblemYou want to give your users a single date selector, where they can choose a month. Then, when they select a month, they should see data from that month and the previous month.Filtering for this month on a date dimension will remove any data from the past month, unfor...

Technical Tips & Tricks

Article Example of using html video tag to embed a video in a Looker table

Last tested:Jun 3, 2020 dimension: video {type: stringsql: 'https://www.w3schools.com/html/mov_bbb.mp4' ;;html: <video width="290" height="130" controls preload="none"> <controls> <source src="{{ value }}" type="video/mp4"> </video> ;;} This content is subject to limited supp...

Technical Tips & Tricks

Article How do I migrate dashboards between instances?

Last Tested: March 21, 2021Here are three options: Make all the UDDs into LookML dashboards, connect the Git repo to the new instance, and then make the LookML dashboards back into UDDs. This Help Center article outlines the manual steps. Use Gazer, a command line tool that migrates content betwee...

Technical Tips & Tricks

1
2
3
4
5
...
68

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