Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Getting started

Getting Started in the Looker Community

  • 153 Topics
  • 281 Replies

153 Topics

izzy
izzyGood Looker
posted in Getting started

👋 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 (like in the screenshot below).  Hey Good Looker! Welcome to the Looker Community    . Feels good to be home, right?This thread is a space for you to share a little more about who you are and all the cool data-related things you are up to! Some questions you could answer to get started are below, but you’re welcome to add anything you’d like to your introduction:What is your name? What is your job title and industry? How long have you used Looker? Trailing or Leading commas in your SQL queries? If SQL isn’t your thing: Column or Bar chart? What’s the 1 Looker/Data related subject that you’d consider yourself an expert on and would love to help others with? (optional) Any other info about yourse

79
C
16 days ago
R
rohit.shoppertrakMember
asked in Getting started

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 2020)

22
Dawid
7 months ago
R
rohit.shoppertrakMember
asked in 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?

12
R
7 months ago
er1k
er1kMember
posted in Getting started

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.

11
Michael
1 year ago
izzy
izzyGood Looker
published in Getting started

Feature Requests: How your feedback makes Looker betterGetting Started

  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 the process of migrating all old Discourse feature requests to the new portal. When that’s done, we’ll have an archive of old FR’s here in the community.Your Feedback Is Important To UsWe know that every company says your feedback is important to them, but it’s hard to think of a major advance that we’ve made at Looker that wasn’t directly tied to customer feedback.Customers told us they needed better-looking, faster dashboards, so we rebuilt our dashboard infrastructure from the ground up. Customers were coming up with amazing workarounds to use scheduled data delivery for alerts, so we built native alerts into Looker. Customers started embedding Looker in other environments, so we develop

86359
H
1 month ago
iglooburner
iglooburnerMember
asked in Getting started

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 way to automate so the chart always shows data that is two days old.  The default pulls in the most recent day which as I mentioned is not complete and skews the data.

8
iglooburner
1 year ago
KukHwa
KukHwaMember
asked in Getting started

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)…???)

6
KukHwa
1 year ago
R
rohit.shoppertrakMember
asked in 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 A V B X 40 B Y  So, I want to group by Field on column A.

6
R
7 months ago
iglooburner
iglooburnerMember
asked in Getting started

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 the date into a day name using the following:coalesce(   index(      list("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"),      mod(diff_days(date(2021,03,01), ${cases_per_hour_kpi.work_dt}) + 1, 7)   ) , "Sunday")However, when I try to Pivot the Table calculation, it shows up in each row and column.  I just want to show Monday underneath the date - currently it shows Monday next to each row of date in the entire column.Any ideas?

6
iglooburner
1 year ago
DCsan
DCsanMember
asked in Getting started

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!

5
DCsan
10 months ago
V
vessrazz
asked in Getting started

question plloute this

pollute

5
A
1 year ago
Tomer
TomerMember
asked in Getting started

Looker platform types

Hi,Where can I find updated information about the Platform types ? Thanks,Tomer

4
Tomer
4 months ago
Crystal_Taren
Crystal_TarenMember
asked in Getting started

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 need it in the data pane. Metric as a dimension Value Sales 1K Email 20 Units 10  

4
A
1 year ago
N
NikiMember
asked in Getting started

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.?Basically I would like to switch between daily charts to aggregated weekly and monthly views with only a click for the Enduser. Thanks in advance for any reply!

4
Dawid
1 year ago
dikshide
dikshideNew Member
asked in Getting started

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 free training materials Are there any other resources out there that might help me prepare? Any advice or tips are welcome. Thanks in advance!!

4
Chandra
1 year ago
nikhilpuri
nikhilpuriNew Member
asked in Getting started

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!

4
Sameet94
11 months ago
R
Ryannn29
posted in Getting started

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 lightning fast), it’s definitely just Looker. It’ll just sit there spinning for quite a long time during all scenarios:when I’m loading on a simple lookml file or just reloading a dashboard page (it’s not the dashboard itself, but the actual page itself just sits there blank)

4
S
9 months ago
iglooburner
iglooburnerMember
asked in Getting started

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) information into Mon, Tue, Wed, Thu, Fri, Sat, Sun.Now I am trying to forecast the remaining days of the month volume based on the actuals that have come in by day so far in the month.  How do I create a forecasted day for each day of the week, and then tie it into how many of those days are remaining in the month? 

4
J
1 year ago
goose
gooseNew Member
asked in 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?

3
ashleyflores
24 days ago
K
KrisPBaconNew Member
asked in Getting started

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.

3
cole.elliott
1 year ago
Bruno Peixoto
Bruno PeixotoNew Member
asked in Getting started

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 month, or quarter, or year.

3
leobardor
9 months ago
E
Eva G. del RiegoNew Member
asked in Getting started

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

3
E
1 year ago
Susan
SusanMember
asked in Getting started

How do I average a daily count over week or month in looker where I need to join the data with other tables

I am new to Looker.I have a table with a count of distinct values grouped by day.I’ve imported into Looker as a view and I want to average the daily count over a month, but all I’ve come up with so far is the total count over a month.  SELECT Date(checkinTime), count(DISTINCT id) AS distinct_ids_count Group by Date(checkinTime)I can’t use this because if I add the id then I have to group by it, at which point the count is 1, repeated over and over.  But without the id column itself, I can’t join to the other tables where it’s a foreign key, so then the data becomes useless.Is there a looker solution to a daily value averaged over longer periods of time? 

3
Susan
5 months ago
mohamed-ali.shiha
mohamed-ali.shihaMember
asked in Getting started

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

3
Dawid
1 year ago
R
rohit.shoppertrakMember
asked in Getting started

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

3
Eric_Lyons
Looker Staff
6 months ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service