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 & management52 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

Welcome

Rules, announcements, and important information

724 Topics

Recently active

Most replies Most views Newest first

Monarch Money hiring first data analyst

Monarch is a subscription based personal finance app (web, iOS & Android). We launched about a year ago and just raised our series A. The team is relatively small at 15 people, fully-remote, and we recently setup Mozart Data (snowflake) with Fivetran and Looker. We also have Amplitude and Segm...

Who's hiring

Article New: Free hands-on Looker training!

Hey all! We’re running a fun Looker Learning Challenge to provide hands-on practice in core Looker skills! This Learning Challenge packages up some of our hands-on learning offerings for Looker - so you or others in your org can spin up a practice instance on demand, and go step-by-step through th...

Challenge

Hiring: Sr. Data Analyst (Remote) at The New Stack

Who is The New Stack? The New Stack is an industry-leading technology publication focused on software engineering, information security, and distributed system operations at scale. We publish our analysis at thenewstack.io. The New Stack is about the services and infrastructures that developers bu...

Who's hiring

Hiring: Freelance Looker Developer (4 weeks - Part Time)

Sepulveda Partners Consulting is hiring a freelance Looker Developer Strong design capabilities and expertise in LookerExperience in BigQueryExperience presenting modeled dataExperience with marketing and media data setsAbout The JobOur team helps marketers and media companies get more value from th...

Who's hiring

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

Getting started

How to connect Looker with SFTP server location?

HI team, I want to extract csv files present on SFTP server. I have SFTP server host name, credentials. How Can I pull csv files from SFTP server into Looker?

Getting started

Article GitHub Authentication Changes Made on January 11th, 2022

Last update: 06:30, Jan 12, 2022 (UTC)GitHub SSH connections in LookML projects and new Marketplace installations are working as expected. What occurred? Due to a 24-hour GitHub brownout on Jan 11, 2022, GitHub connections using SSH in LookML projects and Looker Marketplace installation experienc...

News & announcements

Looker Data Analyst at Beachy

Who is Beachy?Beachy is primarily a B2B cloud-based platform that manages beach resorts and beachside vendor rentals that integrate with Property Management Systems and Point of Sale Systems (PMS/POS) to reliably and quickly deliver food and drink. Basically: we enable you to book your beach chair l...

Who's hiring

How can I connect Microsoft Access DB to Looker?

Our data is currently stored on Access Database. Can someone please help me in connecting MS Access with Looker?

Getting started

Salesloft is Hiring a Data Analyst

Hey Y’all - Salesloft is looking add a Data Analyst to our growing team. This role will report into the Data & Analytics team (I’m the hiring manager) and is remote friendlyThis is a great time to join the Salesloft team in a data focused role. We’ve recently raised another round of funding, val...

Who's hiring

Conversion Rate

Hello!I am attempting to create a look that will show me a conversion rate by dividing the number of newly created customers with 0 orders by the number of newly created customers with >1 orders in a given time frame. I have defined “not converted” as 0 and “converted” 1 by using:case(when (${or...

Getting started

How can I display 2 Dimensions on X axis (bar chart)

Hi, I am trying to create a graph with dimensions: date & name in the X axis, with some measures that are stacked.I’d expect the visualisation to group multiple names that belong to the same date & display the date only once. But that doesn’t happen & as a result part of my x labels is t...

Getting started

Keep original measure colours when displaying a pivoted table

Hi, I have a table with dimensions: date & name, and with a few measures that are stacked.I pre-selected colours for the different measures, but when I pivot by name (I want to have one graph per name with the different dates & stacked measures) I am loosing the original formatting and looke...

Getting started

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...

Getting started

How to create table calculation for measure or field group by one dimension

Hi team,I have three columns ColumnA, ColumnB and Measure in Explore. I want to aggregate sum(Measure ) group by ColumnA.

Getting started

Looker not working

Hello When I open up the web page, the program doesn’t seem to be responding on any clicks/ function/ keys that I select… I also can’t use the search option to look for informationi can find anything when i key in "Collection" in the search bar..

Getting started

Article Customer Success Newsletter - December 2021

Hello Lookers, We wish you a festive and joyous holiday season! Thank you for a great 2021, and we look forward to partnering with you next year. We do not have a release in December, so this newsletter will omit our usual release highlights. Looker Community Spotlight: Community Groups Did you know...

News & announcements

Filter Drop down doesn't show values

Hi team, I have one column which has many dimension values. I want to create a drop down filter which shows all values from the field and client select whichever value or values he needs. This is the field and it has three values: When I create the filter:It force me to enter all the values or if...

Getting started

While doing looker lab Always gets an error

Lab name - Looker Connect data consumer learning journey: Creating new dashboards in Looker Error message - Please create a board with name 'FAA flight data'.When ?- while clicking the check my progress tab.Problem its no where mentioned in the lab that a board ‘FAA flight data’ need to be created. ...

Lesson Comments

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...

Getting started

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?

Getting started

Launch Potato is hiring a remote BI Developer in the Digital Marketing field

Launch Potato is hiring a remote BI Developer!! Apply here YOUR ROLEWe need someone like you to lead efforts in maintaining and transforming enterprise data into actionable information. This entrepreneurial position requires a passion for working with high-volume data sets while having the technica...

Who's hiring

Client Lifespan Custom Calculation

Hello! I am attempting to build a look showing average client lifespan. The applicable dimensions are client_tier_5.admission_date_dateandclient_tier_5.discharge_date_dateIt’s been fairly straightforward to create a calculation to count diff_days between either the admission date and now() or admiss...

Getting started

Microsoft Office error

how to repair my Windows pc with this 0x8063081. while opening or accessing these Microsoft Office applications on my computer or laptop I’m getting some kind of error code or error message Facing issues with Microsoft Office applications like Word, Outlook, Excel and PowerPoint.

Getting started

RedRoute hiring Lead Data Analyst working heavily in Looker

I have been doing part-time contract work with RedRoute (Conversational AI for customer service ), helping them use Looker to improve their product. They are in a period of growth and are hiring a Lead Data Analyst. Salary range is $120k-$180k and the position is entirely remote.I will be leaving in...

Who's hiring

1
2
3
4
...
29

Page 1 / 29

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