Can I use original database table/view in a derived table without importing it as a view or explore in Looker?
I have 4 (A,B,C,D) tables in DB. I have imported A & B as Views (View_A and View_B) and used them in a model e...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Git Error in E Commerce Training Model - ecommerce_teach.git: Auth fail
I am a new bee to Looker. While trying the training hands-on Kitchen table, I am not able to commit changes an...
HTTP GET call from Looker to another site with headers
Is it possible to make an HTTP GET call with headers to another site from a Looker dashboard? We currently hav...
Using Case statements in Filter in Looker Views
I am adding CASE statements to my filter in my views. I basically want that if the user types `Harry` the filt...
12 hour time format on time dimension group
I have a date string in a postgres db"2021-08-09 18:40:54.000+0000"and am converting it to a dimension group w...
Max Date and the Second Max Date
Hi All,I have my data with an ID and each ID has got multiple dates and valuation for each date. My requiremen...
Definitions of grouping functions using Group function
Does anyone know the exact definitions of these conditions using the “Group By” function on the front end of l...
Case when for custom dimension (bucketing)
Hello, I am hoping someone can give advice. I am looking to bucket orders.My goal is to create two custom dime...
[Analytic Block] Peer Comparison: Compare Against Rest of Population
About This BlockNote: you can find an alternative pattern for multi-level peer comparison and “share of wallet...
Issue Staging Data Dynamically
We have a large base_table in our Snowflake database that contains row-by-row transactions from all of our sub...
Snowflake Usage Block
Hi All,I’m new to Looker but enjoying learning my way around.I would like to use this block - https://looker.c...
Problem in implementing Period over Period Analysis
Hi team,I am quite new to Looker so every input is valuable for me.I am trying to implement period over period...
Testing LookML and Looks
I love that Looker has the ability to perform #testing on the data within the #lookML. Great details documente...
Missing data points
When I try to add a tile I get all rows but random data points are missing, no pattern whatsoever. I tried to ...
experience using Spectacles as a part of CI flow
Anybody would like to share experiences as a part of CI flow?We are especially interested in implementations u...
_in_query is not working for Dimension when using it in COUNT custom field
I face an issue with _in_query to properly define sql_table_name. It is not working when dimension is used in ...
Cannot add the set I created in my view in the Explore
Hi there,I have encountered an issue on something that seems very basic (and probably is). I’ve never had this...
can't connect to redshift - a sporadic issue that started yesterday
We are seeing a sporadic issue b/w looker and redshift. This was started yesterday. Our Redshift connection us...
Rank Calculation Issue
I have created Rank using SQL derived table, would like to know how can i make it dynamic.Issue I am facing is...
End-user-defined dynamic tiers
Looker’s tier dimension type is great for defining buckets for breaking out numeric dimensions. For example, h...
Dimension group duration type: sql_start and sql_end parameters
Hi community,I need to use duration dimension to calculate the time between the same column date but based on ...
Help with a query
Sorry, don’t know how to phrase this.I have this source data: date user_id thread_viewed_id 2021-01-01 1 100 2...
Simple month-to-date Forecasting
A very common piece of analysis people like to report on is projecting KPIs out for the remainder of the month...
Autogeneration of model via API / SDK
Hello,When creating a Looker project it’s possible to have Looker auto-generate LookML for you by selecting ‘G...
Bug when generating SQL for BigQuery in function EXTRACT_DAYS()
Something very weird has been discovered by one of my colleagues. They were trying to plot some data with day ...
Comparison : Country in dashboard
Hi, I have country as a dimension in my data and having various metric corresponding to it. I want to allow us...
dashboard link does not pass clicked value
I am trying to link 2 dashboards.I have this in my model:view: account { sql_table_name: account ;; dimension:...
Using Lag function in lookml measure based on condition
I want to calculate the time difference for a device that goes out of bound for some time in LookML. For examp...
Create a measure for sql subquery
Hello everyone i’m trying to write a SQL subquery in looker model but i’m getting error on Athena side can som...
Exclude Null Values Dimension and measure
How toexclude Null Values inDimension and measure
