Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started137 News & announcements123 Who's hiring436 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1778 SQL309
Exploring & curating dataExplores543 Dashboards & looks1524
Application developmentEmbedding Looker / Powered by Looker151 Open source projects53 Looker API368
AdministrationUser access & management68 General Looker administration441
Data science & analyticsGot a question?78 Share your best practices16
コミュニティフォーラム (Japanese)ニュースと告知49 ヘルプとサポート14 コラム69
The Kitchen TableTechnical Tips & Tricks1694 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥1

Ask question / Create topic
Login

Welcome to the Looker Community

8,844 Topics
17,904 Replies
45,386 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 - May 2022

Forum|Forum|5 days ago

450

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

Forum|Forum|3 months ago

3720

How you helped make Looker better in 2021

Forum|Forum|3 months ago

2880

Important notice to Gazer (gzr) users on Looker 22.4+

Forum|Forum|2 months ago

3341

Recently active
Categories
Help others

lijo-1651499852New Member

coalesce in view with two tables

I have a requirement of doing a coalesce by joining two tables. I can do that in explore but as I need that to be used in multiple places I need to have it done in one view. I used the extends in a view but don't know how to join them in the view Derived table is an option but checking if i can use lookml to do that

KavitaNew Member

Dashboards & looks

how to mix different argument types in looker custom field

I am new to the looker. Trying to write a custom field and getting this error. Any suggestions?

anna.lee-1632501121New Member

Removing an always_filter

I have an always_filter in my explore that I want to remove. How does that change affect existing looks that utilize that filter? How can I check which looks are not using that filter in its default setting?

gooseNew Member

Getting started

New Cert After LookML Developer Retired?

I see that at the end of March, the LookML Developer certification exam is being retired, leaving the Looker community with no possible certification to achieve. Is there a reason for this exam (and the analyst one) being retired? Is there going to be a new exam to replace the LookML Developer? If so, when?

paolaLooker Staff

Technical Tips & Tricks

Can you show / hide filters on embedded content?Knowledge Drop

Last tested: Jun 8, 2020 Yes you can! The way to do this is different depending on the type of content.For User defined dashboards, you can use the embed settings option in the cog menu. (click the cog menu on the dashboard > Edit Embed Settings.) For LookML dashboards, you can use the show_filters_bar parameter in the Dashboard LookML file code for your dashboard. For example:embed_style:background_color: "#f6f8fa"show_title: truetitle_color: "#3a4245"show_filters_bar: truetile_text_color: "#3a4245text_tile_text_color: ''show_filters_bar: false For a Look, the filters are hidden by default but can be shown using the Show Filters on Embedded Looks toggle (available as of Looker 7.4). This content is subject to limited support.

Dashboards & looks

Plans to increase email attachment size?

Looker email attachment size is still capped to 15 Mb, but numerous email applications allow more than that now. For example, Outlook now allows a max of 35 Mb:Outlook 35 MB cap Are there plans to increase the attachment size eventually? I forget where to check for feature requests.

holden kusNew Member

Reassign parameter value in LookML

How can I reassign the parameter value by selected value in filter?What I tried to do:{% assign var=_filters[‘view_name.field_name']|split:"," %} {% parameter parameter_name=var%}What did I do wrong?

salvador.manzur-1644425145

Looker Case When Table Calculations

I’m trying to extract New York City borough from a full address field. I want a new custom field that has borough values: Brooklyn, Manhattan, Bronx, etc. I tried doing the following but I’m getting an incomplete expression. I have a user license so I would need to do this in table calculations. Thank you if(contains(${contact.address}, "Bronx","Bronx") = "Bronx" OR contains(${contact.address},"Brooklyn") = "Brooklyn" OR contains(${contact.address},"Manhattan") = "Manhattan") yes,null)

jrose-relaynetworkNew Member

User access & management

How can I allow a user to receive emails again after they clicked "unsubscribe"?

I am a looker admin and a few users have clicked “Unsubscribe” on a scheduled email they had been receiving. Please note that these users do not have a looker account, they are just receiving scheduled emails containing looker data. These users currently do not receive ANY emails from Looker anymore, not just the email from the schedule where they clicked “unsubscribe”.I have tried the following steps to resolve this, but none have worked:I removed their names from the distribution list in the schedule and added them back in. I created a brand new schedule from the same look. I created a brand new look and added a new schedule to that look. I have tried searching the community forums but I don’t see anything showing how to fix this. I saw this post, but the solution proposed does not actually work I have tried checking the user settings for these users, but there is nothing in the menu about changing email preferences for other users (I did this under an Admin account)Please advis

pete-1651452632New Member

AND Date Filter

Hello! I am using Looker to find our historical sales quantities for certain SKUs over a range of time periods.The recent date ranges (last week, last 4 weeks etc.) are easy! I’m struggling to work out how to filter based on a relative date range from before today. For instance, see below, I’m trying to find the # of sales for 28 days from this time last year.(Between 365 days and 393 days ago). I seem to be restricted to OR conditions… no AND. Note, Items Order Date is the only applicable date filter. Could someone please help me understand how I can filter by a range such as the above? Don’t think I have full developer access… I can write a custom filter using LookerML! (as per below).

Welcome

Rules, announcements, and important information

Getting started

137 topics
267 Replies

News & announcements

123 topics
164 Replies

Who's hiring

436 topics
62 Replies

Release notes (archive)

63 topics
512 Replies

Lesson Comments

15 topics
4 Replies

Challenge

10 topics
16 Replies

Looker development

Developing LookML, writing SQL, and modeling data

LookML

1778 topics
4413 Replies

SQL

309 topics
771 Replies

Exploring & curating data

Dashboards, Looks, Visualizations— it all happens here

Explores

543 topics
1465 Replies

Dashboards & looks

1524 topics
3921 Replies

Application development

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

Embedding Looker / Powered by Looker

151 topics
332 Replies

Open source projects

53 topics
157 Replies

Looker API

368 topics
1163 Replies

Administration

Looker set-up and management

User access & management

68 topics
60 Replies

General Looker administration

441 topics
1185 Replies

Data science & analytics

Everything from mean() to machine learning

Got a question?

78 topics
189 Replies

Share your best practices

16 topics
11 Replies

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

ニュースと告知

49 topics
34 Replies

ヘルプとサポート

14 topics
30 Replies

コラム

69 topics
8 Replies

The Kitchen Table

Technical Tips & Tricks

1694 topics
252 Replies

Common Account Questions

14 topics
10 Replies

Blog Archives

347 topics
3 Replies

DCL Mic Drops

5 topics
4 Replies

Video Tutorials 🎥

1 topic
0 Replies

lijo-1651499852New Member

coalesce in view with two tables

I have a requirement of doing a coalesce by joining two tables. I can do that in explore but as I need that to be used in multiple places I need to have it done in one view. I used the extends in a view but don't know how to join them in the view Derived table is an option but checking if i can use lookml to do that

KavitaNew Member

Dashboards & looks

how to mix different argument types in looker custom field

I am new to the looker. Trying to write a custom field and getting this error. Any suggestions?

anna.lee-1632501121New Member

Removing an always_filter

I have an always_filter in my explore that I want to remove. How does that change affect existing looks that utilize that filter? How can I check which looks are not using that filter in its default setting?

gooseNew Member

Getting started

New Cert After LookML Developer Retired?

I see that at the end of March, the LookML Developer certification exam is being retired, leaving the Looker community with no possible certification to achieve. Is there a reason for this exam (and the analyst one) being retired? Is there going to be a new exam to replace the LookML Developer? If so, when?

Dashboards & looks

Plans to increase email attachment size?

Looker email attachment size is still capped to 15 Mb, but numerous email applications allow more than that now. For example, Outlook now allows a max of 35 Mb:Outlook 35 MB cap Are there plans to increase the attachment size eventually? I forget where to check for feature requests.

holden kusNew Member

Reassign parameter value in LookML

How can I reassign the parameter value by selected value in filter?What I tried to do:{% assign var=_filters[‘view_name.field_name']|split:"," %} {% parameter parameter_name=var%}What did I do wrong?

salvador.manzur-1644425145

Looker Case When Table Calculations

I’m trying to extract New York City borough from a full address field. I want a new custom field that has borough values: Brooklyn, Manhattan, Bronx, etc. I tried doing the following but I’m getting an incomplete expression. I have a user license so I would need to do this in table calculations. Thank you if(contains(${contact.address}, "Bronx","Bronx") = "Bronx" OR contains(${contact.address},"Brooklyn") = "Brooklyn" OR contains(${contact.address},"Manhattan") = "Manhattan") yes,null)

jrose-relaynetworkNew Member

User access & management

How can I allow a user to receive emails again after they clicked "unsubscribe"?

I am a looker admin and a few users have clicked “Unsubscribe” on a scheduled email they had been receiving. Please note that these users do not have a looker account, they are just receiving scheduled emails containing looker data. These users currently do not receive ANY emails from Looker anymore, not just the email from the schedule where they clicked “unsubscribe”.I have tried the following steps to resolve this, but none have worked:I removed their names from the distribution list in the schedule and added them back in. I created a brand new schedule from the same look. I created a brand new look and added a new schedule to that look. I have tried searching the community forums but I don’t see anything showing how to fix this. I saw this post, but the solution proposed does not actually work I have tried checking the user settings for these users, but there is nothing in the menu about changing email preferences for other users (I did this under an Admin account)Please advis

pete-1651452632New Member

AND Date Filter

Hello! I am using Looker to find our historical sales quantities for certain SKUs over a range of time periods.The recent date ranges (last week, last 4 weeks etc.) are easy! I’m struggling to work out how to filter based on a relative date range from before today. For instance, see below, I’m trying to find the # of sales for 28 days from this time last year.(Between 365 days and 393 days ago). I seem to be restricted to OR conditions… no AND. Note, Items Order Date is the only applicable date filter. Could someone please help me understand how I can filter by a range such as the above? Don’t think I have full developer access… I can write a custom filter using LookerML! (as per below).

gweiss-1637612719New Member

Dashboards & looks

Dashboard download is not working

When I click on “Download” from the dashboard’s three-dot menu, I am taken to the same dashboard in a separate tab but nothing pops up to allow me to download a PDF or CSV of the dashboard. Does anyone know how to troubleshoot this? I am doing this while on Chrome.

Upcoming events

Most active members

No activity yet!

Show full leaderboard

Powered by inSided

Terms & Conditions

© 2021 Looker Data Sciences, Inc.
community@looker.com
Privacy | Terms | Cookies | Community Guidelines

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