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...
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
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...
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
How do I dynamically switch view name in sql parameter of dimension?
There is a "rate" dimension in “masterdata” view using "${corp_1.date}" in sql parameter.explore: corp_1 { joi...
Merging Two Explores
Does anyone know how to merge two explores by month? When I click the gear icon on my primary explore I cannot...
Federated query from multiple backend instances
I have Looker dashboard, which needs to marshal data across two Snowflake instances - one in AWS and the secon...
Calculating the number days in the timestamp filter
Hi,I’m new to looker.I want to calculate the number of days in the timestamp filter.For example:If I have filt...
Looker and Sybase IQ
Is there support for Looker connecting to Sybase IQ?
Looking for an option to send an email with the saved filename & its file location of 'Amazon S3' from looker scheduler when using S3 scheduler
I'm looking for an solution or workaround to send an email with the saved filename & its file location after s...
Can we create a custom measure which excludes which excludes the main filters in a look?
A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes t...
Seeking for the best LookML development system in our ads agency
15 marketers and 1 LookML developer use Looker at our digital ads agency in Japan. Each marketer gives his/her...
Change Value format display in bps
Hi,I want to customize value format to be display in bps. For example, 0.0123 will be displayed as 123 bps. Is...
BigQuery Machine Learning (BQML): LookML Syntax Explanation
Hi all,BigQuery Machine Learning (BQML) is a BigQuery’s feature that allows users to create and execute machin...
Looker on SAP HANA Calculation View
Hello,Have used Looker as a reporting tool using SAP HANA calculation view as source.Consuming SAP HANA calcul...
