Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started113 News & announcements112 Who's hiring414 Release notes (archive)63 Lesson Comments12 Challenge10
Looker developmentLookML1561 SQL284
Exploring & curating dataExplores490 Dashboards & looks1355
Application developmentEmbedding Looker / Powered by Looker132 Open source projects48 Looker API331
AdministrationUser access & management51 General Looker administration414
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
Welcome
Getting started

Getting started

Getting Started in the Looker Community

113 Topics
241 Replies

When you subscribe we will email you when there is a new topic in this category

113 Topics

Most replies

Recently active Most views Newest first

👋 Introductions Thread

You will likely want to unsubscribe from this topic, unless you want to get a lot of emails! While we work on a better solution, make sure that after you post, you toggle the Subscribe button off, as it will automatically turn on after you post in the thread. You want the star to be white/empty (lik...

How to calculate Sales Date dimension

I have one date dimension_group “transaction_date”(Year, month, month num...) and one column sales. I need to create three measures or columns which works dynamically Sales of latest year and latest month(Dec 2021) Sales of latest year and this month(Nov 2021) Sales of last year and this month(Dec...

How to convert hour in number to human readable like 1 AM, 2 AM ..

Hi team,I have a date dimension group which has date in raw form. I need to convert below chart which has hour in 12 hours format.I have used hour_of_day but this gives me 0,1,2,3,4,5,6… 23.I need dimension as 12:00 AM, 1:00 AM.. Can you tell me how to achieve this?

New Community Bugs and Questions

I think there are and will be some initial bugs with the new rollout. As there might be many minor issues then I thought to start a new topic around this. Also maybe to include some questions about the new layout.

Article Migrating your old Discourse account

This post only applies to users that were members of discourse.looker.com and are looking to log into the new community for the first time. New User? Go here.So you’re an OG Looker Community member, looking to migrate your account from Discourse to the new community forums? Fantastic. Follow these...

Creating a 2 Day Lag in Looker Chart

I am trying to create a 2 day lagged report because my data is not complete until 2 days after the work date. For example, my chart today shows data through 3/22/2021. However, 3/21 and 3/22 are not complete - which skews the charts. I want to only have the chart showing through 3/20. Is there a w...

Article Feature Requests: How your feedback makes Looker better

We have fully transitioned to the method of feedback described below. While you can of course discuss new and desired features right here in the online Community, in order to get your vote counted and officially surface your idea to our product team, please follow the instructions below. We are in...

How to exclude a specific pivoted column from table calculation?

Hello Looker community, if I want to calculate a Mean of total across the whole row, EXCEPT the last column (80 or Above), what should I do? Mean (pivot_row(products Count)…???)

How to aggregate the measure values to one dimension values

Hi team, My requirement says Sum of the field or aggregate with sum function w.r.t columnA, Raw data: ColumnA ColumnB A U 10 A V 10 B X 20 B Y 20 Required table:ColumnA ColumnB Measure A U 20...

Pivot Table Calculation

I am trying to convert a date into a week day name, and have it displayed underneath the full date in the visualization.For example, my data shows dates across the top (3/1/2021, 3/2/2021, etc). Underneath the dates I would like to display the day of the week.I did a table calculation to convert th...

how to share a SQL query?

I’ve created a basic sql query which means I needed to use developer mode.It’s “committed and pushed” with looker’s git web gui.but nobody else on the team can access it, when I share the link.I was expecting this to be a simple task!

question plloute this

Metric Selector Parameter as column

I would like to create a list of metrics as a dimension so I can create the following. I would then need to figure out how to create the second columns that does the correct aggregations. all the documentation I have found only shows the dimension as filter field only when used in a parameter, but I...

Looker Dashboard - Filters: Switch between monthly, weekly, daily views

Hello Community,I am creating a looker dashboard, based on the -let’s say- last 5 days with a barchart of certain metrics per day, and would like to add a filter on the top of the dashboard to show me they last 5 weeks (or last 5 month etc.)Is that possible to switch easily between days, month etc.?...

Looker Business Analyst certification!

Hi All, I would appreciate any help in my Looker BA Certification journey. I have been trying to interview and a lot of the places that I would LOVE to work at use Looker. I have been trying to get enough experience to get certified but I have not been able to pass the certification with just the fr...

Not able to access sandbox

Hi Community members,I am currently on the LookML section of Looker training and it asked me for my email address to be able to access the learn.looker.com sandbox environment. It’s been over 12 hours but i haven’t received any access email. Please advise. Thanks!

Looker’s recent slowness

Has anyone else noticed Looker’s slowness recently? I feel I used to encounter Looker being slow maybe once a week, usually in the evening. But as of recently, there are now periods of slowness throughout every single business day of the week. My internet’s fine (everything other website loads light...

Forecasting month volume by days of the week

I am trying to forecast my monthly case volume by using month to date actuals, by day, as the predictor. My daily volume fluctuates dramatically - so if I have 5 Fridays in a month vs 4 Fridays my volume can be very different. I have created a custom dimension to convert Work Date (DD-MM-YY) inform...

How to flag spam in community messages

I recently got a private message in my Community inbox from someone asking me to email her to become her friend and get access to her pictures. Is there some way to flag that as spam, or at least block the user. I’m not seeing any such options.

How can I drill down in Looker?

Hello! Let's suppose that I have a table with 2 columns: date and sales. Then, I created a graph, where the X axis is date and Y is the sales. Is there a way to control how date is grouped just like a drill down in Datastudio? Example: if a click in a button, the date will be organized by week, or m...

Error in Commit History of Git Actions

Hi,I can’t access to “Commit History” in Git Actions menu. I get the error: “TypeError: l.map is not a function”. It happens in all branches of the project. Thanks, Eva

Preparing for Looker Certification

hi everyoneCurrently using Tableau and want to take Looker training and certification. Any help how to get the software on my personal laptop to explore and get hands-on experience before the certification?ThanksMohamed-Ali Shiha

How to load csv file present on developer local drive to Looker?

I have access of Looker instance and I use my company email to access Looker. I have a csv file which is locally available in my laptop drive. How can I load it to Looker? Thanks,Rohit

Dashboard filter to update after another filter

Hi! I have a dashboard that has visualitzations from two explores and each explore has two filters on the dashboard like this: What I need is that when I select a value for the Access filter, the Sport Breakdown Access filter updates to match the same value. And the same for the Country and Sports b...

How to start working on Looker?

I am interseted in working on Looker. I am a Data enthusiast who is currently working on Tableau and want to check Looker as it look more promising. But I am unable to get a download file to install Looker in my Desktop. Can anyone please help me get one.

1
2
3
4
5

Page 1 / 5

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