Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started141 News & announcements125 Who's hiring493 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1830 SQL319
Exploring & curating dataExplores557 Dashboards & looks1563
Application developmentEmbedding Looker / Powered by Looker155 Open source projects54 Looker API376
AdministrationUser access & management70 General Looker administration452
Data science & analyticsGot a question?83 Share your best practices16
The Kitchen TableTechnical Tips & Tricks1739 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥4
コミュニティフォーラム (Japanese)ニュースと告知50 ヘルプとサポート14 コラム69

Ask question / Create topic
Login

Welcome to the Looker Community

9,054 Topics
18,100 Replies
48,809 Members

Find answers to your questions
Stay up to date on the latest topics
Ask questions and help others

Ask your question

Getting started

New user? Click here to get started in the Community.

Events & (Virtual) Meetups

Learn about our awesome events

Looker Connect

Level up your knowledge with Looker's training hub

Community Groups

Find others interested in the same topics as you.

What's New

Get the latest news about Looker & the Community

The Kitchen Table

A collection of Looker knowledge for you to explore

Stay up to date with the latest

Customer Success Newsletter - June 2022

Forum|Forum|7 days ago

770

Product Announcement: Introducing new in-app tutorials & onboarding guides

Forum|Forum|5 months ago

4740

How you helped make Looker better in 2021

Forum|Forum|4 months ago

3310

About Video Tutorials 🎥

Forum|Forum|28 days ago

910

Recently active
Categories
Help others

cmcooper-hcNew Member

LookML

"Error: view not found" when others access my dashboard

I created a personal dashboard and then copied the LookML into my project and deployed to production. I could, and still can, see everything in the dashboard clearly. However, when my coworkers attempt to access it they see the following: { "data": { "error": "View Not Found" }, "dashboard_element_id": "7", "id": "2232ac51b3677dd7f9a9fda7c3576dfb", "status": "error"}I have verified that they have permission to see the dashboard. What could cause this error?

22 minutes ago

maxcorbinLooker Staff

Technical Tips & Tricks

How to Count Only Weekdays Between Two Dates

Looker will not be updating this content, nor guarantees that everything is up-to-date. If you'd like to count the days between two dates, you could use the SQL DATEDIFF function, which simply counts the days between two points in time:Redshift:DATEDIFF('day', start, stop) AS daysPostgres:DATEPART('day', start - stop) AS daysMySQL:DATEDIFF(stop, start) AS daysSnowflake:DATEDIFF('day', start, stop) AS daysHowever, the functions above will count all the days between the two specified dates. What if you want to exclude weekend days (Saturday and Sunday)?One way of achieving this is to create a derived table with the necessary logic. But, there is a more straightforward way, using a single short query, which you can define in the sql parameter of a dimension or measure in LookML.Note:You will want to make sure your database will return a day of week index of 0 for Sunday and 6 for Saturday; this is important, or the calculations will be one or two days off. You will also want to make sure

1981

1 hour ago

kuopazMember

LookML

Clause in LEFT JOIN rather than WHERE

Following a Community post from 2015, this can be done by using a filter (not dimension) and then ‘passing it’ to dimension in the LEFT JOIN using {% condition %} . . . {% endcondition %}. It seems quite involved for such a common requirement when writing SQL queries? Then make the dimension visible but with can_filter = no. To the user of the explore, it looks like the dimension appears twice - once via the filter, and again as the usual dimension?

2 hours ago

lloydtabbLooker Staff

LookML

Edda O.New Member

Got a question?

How to stop Chi-Squared function from using null values?

I would like to utilize the chi-squared built-in function to get p-values for each experiment (pivoted, in this example aa00 and aa01), when comparing expected vs observed values. However, if one experiment has more variants then the other (aa01 only has control and 1 variant), the chi-squared function thinks the null value is some input somehow and uses it in the calculation. The results are correct for aa00, but for aa01, it should be 0.014786. I assume that, as it is counting the null value of Variant 2 (that does not exist for aa01), it returns 0.051257 instead. I tried creating a dummy variable (non-null variant) and including an if statement within the chi-squared test, but it didn’t make any difference. It does work if I create a filter and filter only by aa01: But I would like to see all of them at the same time. Any tips on what could solve the issue? Edit: The table calc I’m using is:chisq_test( ${chi_square_example_dt.observed_measure}, ${chi_square_example_dt.expecte

5 hours ago

michael1978New Member

Explores

SQL query for merged results

Hey! Is there any way to see the sql query for merged results like it is seen for regular queries?If not then maybe can someone help me understand the merge logic and how to replicate it in a query?The combining merge values are:public.items AS items ON vendor_integrations.items_uuid = items.uuidpublic.items AS items ON (client_integration_groups.items_uuid::uuid) = (items."uuid")Thanks!

5 hours ago

jhgafNew Member

LookML

Liquid date filter

Hello everyone,I am trying to build a chart that shows two values : the number of views of a publisher’s videos and the # of posts during a given period of time, just like this : I built a filter that filter by the activity of a video : it will return the number of views all of our videos made during May 22 for instance.However, i would like to have on the same chart the number of videos posted in may (so in that case it would reference another type of time period : publication_date). So I have two dates dimensions : activity and published. I’d like to have only one global filter for the user.How can I build a filtered measure for the # posts that would listen to the date range i chose in activity and apply published to the # of post instead ? Thank you in advance ! Paul

5 hours ago

gdemontalivetLooker Staff

LookML

quick custom topojson shape on a map

Hi, I struggled to find an easy explanation on how I can easily display my own shapes on a map and then match data with it and display them on a looker viz. So to remember how I did it, I amgoing to document it here. This is detailing the 2 posts from here and here to create the shape and here about how to put it in looker. I am just putting them together to explain more in details.First thing is to create the shape on the map. For this, I used this tool http://geojson.io/ just draw the shapes or dots you need on a map: then the important step is to attach a unique code to each shape so that you can link each shape to a value in Looker’s dimensions. For this, just click on your shape and then add the name of dimension you will be using and then the value that is the one you would get in your database: if I click on another shape, I will also put “id” but with a different value: once you have created all your shapes, jsut download them as topojson:next, you upload the file in Looker:y

6 hours ago

Welcome

Rules, announcements, and important information

Looker development

Developing LookML, writing SQL, and modeling data

Exploring & curating data

Dashboards, Looks, Visualizations— it all happens here

Application development

Extensions, open source tools, the Looker API, and embedding Looker

Embedding Looker / Powered by Looker

155 topics
335 Replies

Administration

Looker set-up and management

Data science & analytics

Everything from mean() to machine learning

The Kitchen Table

コミュニティフォーラム (Japanese)

コラム

69 topics
8 Replies

cmcooper-hcNew Member

LookML

"Error: view not found" when others access my dashboard

22 minutes ago

kuopazMember

LookML

Clause in LEFT JOIN rather than WHERE

2 hours ago

lloydtabbLooker Staff

LookML

Conditions in Join Clauses (3.20+)

3 hours ago

benitodelacruzNew Member

General Looker administration

using SendGrid template in looker schedule notification

Is there is a way to use a sendgrid template from looker schduled notification?

5 hours ago

Edda O.New Member

Got a question?

How to stop Chi-Squared function from using null values?

5 hours ago

michael1978New Member

Explores

Liquid date filter

5 hours ago

fowlerjkNew Member

Dashboards & looks

Some PDF/schedule rendering problems lately

We are using Looker 22.10.32. I’m not sure of when this started, but it’s been after one of the updates a few months back. All seem to be related to PDF rendering.Column headers are getting cut off, squeezed, and generally messed up Columns themselves are getting cut off no matter how we try to format the PDF Most notably, some dashboards will show up just fine on web, but when trying to schedule or download, we get this error: query failed: Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sumThis has been happening for a while and we have been in contact with support, but it just seems to be a black hole. Can we get some answers on why this is happening?

6 hours ago

Adrian_TriteanuMember

LookML

Dynamically call constant

Hey guys, does anyone know if it is possible to dynamically call a constant based on one parameter the user selects? I have two constants defined in the manifest file: constant: schema_version__de { value: “v1” export: none } constant: schema_version__at { value: “v2” export: none } I defined a parameter: parameter: country_code { type: unquoted default_value: "de" allowed_value: { label: "DE" value: "de" } allowed_value: { label: "AT" value: "at" } } } and inside a view i need to create the mapping to a table: sql_table_name: `my_database.@{schema_version__{% parameter country.country_code %}} so that the constant is picked up based on the user country selection. Unfortunately this does not work. The output is: SELECT * FROM my_database.@{schema_version__de}.my_table Thank you.

8 hours ago

ankit123New Member

LookML

Add weekend to a time_period parameter

Hey Guys,I have a time_period parameter that has values for Day, Week, Month, Fiscal Month. Can anyone suggest how I would go about adding a Weekend (Fri-Sun) value to this?parameter: time_period {type: unquoteddefault_value: "Week"allowed_value: { value: "Week" }allowed_value: { value: "Day" }allowed_value: { value: "Month" }allowed_value: { value: "Fiscal_Month"label: "Fiscal Month" }}

11 hours ago

Upcoming events

Most active members

No activity yet!

Show full leaderboard

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.