Stack Overflow
Stack Overflow

Questions tagged [looker]

Use this tag for questions concerning use of the Looker platform or its modeling language, LookML.

The Looker data platform is a web-based service for data exploration, analysis, and reporting with built-in version control and security features. Google announced in June 2019 that it would acquire Looker Data Sciences.

LookML is a declarative data modeling language somewhat similar to YAML or JSON that defines relationships in relational databases so that users of the Looker platform can explore data without writing SQL.

Components of LookML and their related SQL concepts:

  • dimension (column)
  • measure (aggregation)
  • view (table)
  • explore (join)
  • model (database)

Data types peculiar to LookML include:

  • duration
  • yesno (equivalent to boolean)
  • location
209 questions
0
votes
0 answers

i'm trying to convert my data to lat lng coordinates in looker

dimension: bounds { type: location sql_latitude: ST_Y(ST_Centroid(ST_Transform(${TABLE}."bounds", 4326)));; sql_longitude: ST_X(ST_Centroid(ST_Transform(${TABLE}."bounds", 4326)));; } I would like the drawing to be in polygon…
GHCouto
  • 15
  • 6
0
votes
0 answers

Looker: Unable to show Subtotals when group in 2 levels

So I have created 2 Custom Dimension to group our people with their designated Team and Managers. First Dimension is for Teams, while 2nd one is Managers. As I see the scorecard of our employee, I want to see also the Team Score, so by ticking the…
Mark Rebucas
  • 37
  • 3
0
votes
0 answers

Sending multiple parts of a Looker dashboard but not all parts in an email scheduled delivery?

LOOKER has the ability to send either the entire dashboard or a single look via eMail to a person. Currently we want to be able to send either a portion of a dashboard or multiple looks in the same email. Example we have 4 tiles/looks inside a…
Mike - SMT
  • 14,784
  • 4
  • 35
  • 79
0
votes
3 answers

Aggregate values ignore groupby while select

I have table: sku warehouse sellable_units location A 1 10 x B 2 30 x C 1 10 y i can not ignore group_by warehouse because i am using looker.the looker genrated query is: select warehouse,sum(sellable_units) from table group by 1…
parichay
  • 1
  • 2
0
votes
1 answer

Structuring looker Explore Results

I’m having trouble figuring out how to count publications in my Looker data set by year and author. In my Looker explore the data Looker table results look like this: Pub_id year author author_id 1_1 2021 john 5.5 1_2 2020 john 5.5  …
dalek_fred
  • 153
  • 10
0
votes
1 answer

issue with closing tag in liquid looker any help would be great

I was wondering if anyone could help me - I've been building out a custom PoP dimension in Looker - this appears to be working fine but I keep getting the error that my if tag hasn't been closed. I'm certainly not an expert in liquid, but I can't…
Khan Beebee
  • 1
0
votes
1 answer

How to order Looker Filter Options when string

Currently, I have a filter that is a string, so it's ordering the options like this: The order of the options is incorrect, as you can see $1M is right after $15k and before $200k. Without prefixing the values with something "A." , "B.", "C.",…
mikelowry
  • 1,307
  • 4
  • 21
  • 43
0
votes
1 answer

How to chart two metrics from aggregated table in Looker?

I am trying to make a line chart with two metrics vs date. I am querying an already aggregated table. When I add three columns to the visualization, date and 2 numeric fields and pick scatter plot or line chart, only two numeric fields are charted.…
Gofrette
  • 468
  • 1
  • 8
  • 18
0
votes
1 answer

How to change url params of url on Looker dashboard based on dashboard filters

I have a dashboard in Looker which contains a button that is a url that goes to another look with more granular data than the dashboard. What I want to do is change the url params of this button based on what the user chooses in the filters on the…
Chadc
  • 53
  • 4
0
votes
1 answer

How to chart a line and a fixed point in the same chart in Looker

I want to compare precision-recall curve of my model to current rule based model precision-recall. So I want to have a chart with a line and a fixed point. Data looks like following: threshold precision recall current precision current…
Gofrette
  • 468
  • 1
  • 8
  • 18
0
votes
1 answer

Embed python into looker

Is there a natural way to wrap Python code to display in Looker? The ideal dataflow for my problem is SQL DB->python-> looker, or alternatively, looker->python-> looker.  I am hoping to embed a.py into lookML so that I can automate python analysis,…
Jacb
  • 1
  • 1
0
votes
0 answers

Simple Query - Need to find Avg Item Rating for only certain items

Goal: I am trying to find the Average Item Rating for all items except Issue Items of a specific issue type. Sounds simple, right? Well, it’s been a while since I took CS 101, so I need some help. For reference, I am using this information to create…
virtualrealism
  • 1
0
votes
1 answer

looker dev difference between PDT and regular DT

LookerML question: I have got this snowflake query which joins one static table (does not refresh) and one table that refreshes every day. I want to pop this query into Looker and create a simple Looker dashboard using it. Two options I think are…
Pandafreak
  • 109
  • 1
  • 12
0
votes
2 answers

IF statement and CASE WHEN statement with two conditions used together

I would like to achieve the following in looker SQL (hence the $): If my count ${count_students} > 0 and the ${subject} is NOT ('Biology') then the cost of the class should be provided. ...however if my count ${count_students} = 0 and the…
Pandafreak
  • 109
  • 1
  • 12
0
votes
1 answer

Looker Dashboard Query

I am new to Looker and creating a dashboard. I have to get the previous device of customers who have purchased a particular product. For example, user A has purchased 'Phone 1' on 1st July 2022 'Phone 2' on 12th May 2022 'Phone 3' on 10th Jan…
anshika goel
  • 11
  • 3
1 2 3
…
13 14