Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started136 News & announcements123 Who's hiring436 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1773 SQL308
Exploring & curating dataExplores541 Dashboards & looks1519
Application developmentEmbedding Looker / Powered by Looker151 Open source projects53 Looker API368
AdministrationUser access & management66 General Looker administration440
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,827 Topics
17,887 Replies
45,067 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|3 days ago

260

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

Forum|Forum|3 months ago

3700

How you helped make Looker better in 2021

Forum|Forum|3 months ago

2860

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

Forum|Forum|2 months ago

3291

Recently active
Categories
Help others

JerviNew Member

GoogleJsonResponseException: API call to bigquery.jobs.query failed with error: Access Denied: Project ppc-big-query: User does not have bigquery.jobs.create permission

I’m having issues running a BigQuery function from the submit button in the sidebar. The query function works perfectly when running it either from the editor or via custom menu. However, it keeps failing whenever the submit button is clicked. I’m using google.script.run for the submit button. Hope someone could help. Thank you!

punitbopcheNew Member

Looking for BI Lead/Architect opportunity

Hi Community, Reaching out as I am looking for opportunity in BI domain particularly in Looker as BI Lead/Architect. I have 6+ yrs. of experience leading teams, setting up BI Infra from ground up & experience of building end to end Looker Embedded Applications.I want to continue this journey & will love to discuss any project or opportunity available.Note: I am based out of India but open for work with some overlap b/w IST & other Time zones.Thanks,Punit BLinkedInEmail: punitbopche@gmail.com

FaroukNew Member

Platform Developers

Pivot only one part of a table

Can we pivot only one part of a table in looker? I wanted to create a table with each row represents the total purchases of each item with a pivot part to add where people made their purchases, which is another dimension.The table will be using multi-pivoting btw, each pivot will be done on a section so that we can see more about the data in each row. its something like this:

dj200Member

Embedding Looker / Powered by Looker

Create a new dashboard/look as an embed user

As an embed user, can I create a new dashboard/look and share with another embed user?

Analytics JobsNew Member

Looker Implementation experience

Looking for highly technical person with Looker implementation at an Awesome company - Ciena!! Person must have problem solving attitude!

kshah7Member

How to hide view label/group label from drill fields when display to the user

Hi, Right now whenever I add drill_fileds to dimensions, it will display view_label.label. Is it possible to just display label without view_label, like what we have in table visulization to hide view reference?

StefanMember

Dashboards & looks

Dates incorrectly displayed after Look is downloaded to Excel - Unparseable date

Hi,Date entries are shown as follows, Unparseable date: 'Wed Mar 02 00:00:00 UTC 2022' after I download to Excel. Dates are shown correct when Look in Excel format is sent via email.This data has been downloaded to Excel before without any issues.Any help is greatly appreciated.kind RegardsStefan

aaron.liang-1629127787New Member

Dashboards & looks

How can I recover a deleted tile in a dashboard?

I removed a text tile from a dashboard about a week ago, but now I would like to recover the contents of this tile. Is there some tool which would allow me to recover this tile, or any form of version control available for dashboards?

alessandro.pipitone-1641984540New Member

Dashboards & looks

Filter Default value using user attribute

Hi everyone, I am struggling to find a way to set the Default Value of a Dashboard Filter equal to the user attribute.This is the case:I have a dashboard with a filter named “Country”. Each user has a user_attribute called “Country”.What I would like to have is to have a default value for the filter “Country” equal to the contry of the user that is entering the dashboard.Do you know if there is a wat to do it?I tried many things, but there seems not to be a way to do it.Thanks for your help

stephen.kyriacou-1638527563New Member

Table Calculations in quickstart queries

Are there any plans to allow the query parameter (for quickstarts) to contain table calculations?

Welcome

Rules, announcements, and important information

Getting started

136 topics
266 Replies

News & announcements

123 topics
164 Replies

Who's hiring

436 topics
61 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

1773 topics
4410 Replies

SQL

308 topics
768 Replies

Exploring & curating data

Dashboards, Looks, Visualizations— it all happens here

Explores

541 topics
1463 Replies

Dashboards & looks

1519 topics
3916 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
1162 Replies

Administration

Looker set-up and management

User access & management

66 topics
60 Replies

General Looker administration

440 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
33 Replies

ヘルプとサポート

14 topics
30 Replies

コラム

69 topics
8 Replies

The Kitchen Table

Technical Tips & Tricks

1694 topics
251 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

JerviNew Member

GoogleJsonResponseException: API call to bigquery.jobs.query failed with error: Access Denied: Project ppc-big-query: User does not have bigquery.jobs.create permission

I’m having issues running a BigQuery function from the submit button in the sidebar. The query function works perfectly when running it either from the editor or via custom menu. However, it keeps failing whenever the submit button is clicked. I’m using google.script.run for the submit button. Hope someone could help. Thank you!

FaroukNew Member

Platform Developers

Pivot only one part of a table

Can we pivot only one part of a table in looker? I wanted to create a table with each row represents the total purchases of each item with a pivot part to add where people made their purchases, which is another dimension.The table will be using multi-pivoting btw, each pivot will be done on a section so that we can see more about the data in each row. its something like this:

dj200Member

Embedding Looker / Powered by Looker

Create a new dashboard/look as an embed user

As an embed user, can I create a new dashboard/look and share with another embed user?

Analytics JobsNew Member

Looker Implementation experience

Looking for highly technical person with Looker implementation at an Awesome company - Ciena!! Person must have problem solving attitude!

kshah7Member

How to hide view label/group label from drill fields when display to the user

Hi, Right now whenever I add drill_fileds to dimensions, it will display view_label.label. Is it possible to just display label without view_label, like what we have in table visulization to hide view reference?

aaron.liang-1629127787New Member

Dashboards & looks

How can I recover a deleted tile in a dashboard?

I removed a text tile from a dashboard about a week ago, but now I would like to recover the contents of this tile. Is there some tool which would allow me to recover this tile, or any form of version control available for dashboards?

alessandro.pipitone-1641984540New Member

Dashboards & looks

Filter Default value using user attribute

Hi everyone, I am struggling to find a way to set the Default Value of a Dashboard Filter equal to the user attribute.This is the case:I have a dashboard with a filter named “Country”. Each user has a user_attribute called “Country”.What I would like to have is to have a default value for the filter “Country” equal to the contry of the user that is entering the dashboard.Do you know if there is a wat to do it?I tried many things, but there seems not to be a way to do it.Thanks for your help

stephen.kyriacou-1638527563New Member

Table Calculations in quickstart queries

Are there any plans to allow the query parameter (for quickstarts) to contain table calculations?

DineshKumarNew Member

Dashboards & looks

Conditional formatting of a measure based on another dimension/measure

Hello folks, I have a requirement in looker, where in a table chart I have a measure whose values are calculated based on a CASE statement. These values should fill bg color(conditional formatting) in individual cells based on another dimension. Is it possible in looker? Many Thanks,Dinesh

sofypondNew Member

Dashboards & looks

Calculating average in row totals without taking zeros in count

Hello,I have a table on Looker where I have added the Totals option from the Explore view.As I am calculating percentages, Looker is return the mean or average in the Totals row, as expected. The issue comes when I have zeros on any of the rows, which is calculating the average by counting those zeros. For example, in the following image, the average should be 18.14%, not 5.85%.I have tried creating a table calculation to replace the zeros with nulls, but it is still not working:The formula that I am using in LookML is the following one: measure: d30_net_total_roas { type: number sql: safe_divide(${d30_net_total_revenue},${spend}) ;; description: "Day 30 ROAS %" label: "Day 30 Net ROAS %" group_label: "DX Total ROAS %" value_format_name: percent_2How can I fix this so it doesn’t count zeros or nulls to calculate the average in the totals row?Thanks!

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