[Analytic Block] Retention Analysis
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
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
Looker View - How to SUM a COUNT_DISTINCT Measure
Hello fellow Lookers, I have a View file that contains a Measure to COUNT_DISTINCT Id’s. I apply this Measure ...
Modeling nested data in Big Query Standard SQL
With the release of Big Query’s Standard SQL dialect, it’s now much easier to model nested data sets in LookML...
How to handle null values for dimensions
Hi all! I have a fact and dimensions table. The fact table have a measure. When I group the measure by a dimen...
Two WITHs
If I write a PDT whose SQL starts with with foo as and include in the PDT a reference to another non-persisten...
Using Liquids _filters Variable for Dashboard Linking
Use Case From to time, end users would like to navigate to a dashboard from an explore while being allowed to ...
[Retired] Using Native Derived Tables
This article has been retired as the information is now in documentation on this page. If you reached here fro...
Extending dashboards filters
I would like to a dashboard by setting a value of a filter. Here are my dashboards: - dashboard: summary_repor...
Seasonal Sales Forecasting
Scenario In a related post, I illustrated a pattern that allows for some lightweight linear forecasting of mea...
Automating Frequently Changing Schemas with AWS Lambda
Why would you need this article? When you have tables and table schemas that are constantly in flux, but still...
How to implement partition by function in LookML
There is a table, for example Product / Order / Price A / 1 / $6 A / 2 / $11 A / 3 / $7 B / 4 / $8 B / 5 / $12...
Dimensionalize a Measure: Cohort Tiers on a Count
The purpose of this article is to understand how to group by information in your database which is only availa...
Sequencing Transactions With Window Functions
Sequencing Transactions is a very common analytical pattern. In the example below, we will compute a sequence ...
How to divided a measure of type Sum by another measure of type Count
Hi, I have this measure in a derived table : COALESCE(SUM(CASE WHEN ((DATE(sql_activity_days.sale_date )) - (D...
Dynamic Timeframes for Dimension Groups with Parameters
Often our business users want to change timeframes on the fly - our internal teams report in weekly cycles whi...
Multiple connections in one model
Hi, I’m new to Looker and I’m trying to figure out how to have a model that uses more than one connection - as...
Fabio's Opinionated LookML & SQL Style Guide / Ruleset
As a Customer Success Engineer here at Looker, I’ve spent quite a bit of time working on a diverse set of mode...
Using LIKE operator and wildcards with Parameters
Is there a way to use a free-text parameter in a fuzzy “LIKE” statement including wildcards? For example - I h...
[Analytic Block] Creating a Median Aggregate Function in BigQuery with a User Defined Function
About this BlockBigQuery allows for the creation of User Defined SQL function written in either SQL or Javascr...
How to zero fill dates in Looker
A daily_usage table can be useful for summarizing usage per day. But what if there is a day without any usage ...
Required_fields and pivoting
has anyone experienced the following error when using required_fields in a measure and then trying to pivot in...
Cumulative Sum in MySQL
Cumulative Sums are a little tricky in MySQL. The simplest way to tackle this would be to use the running_tota...
Redshift Spectrum and Looker
Hi all! Have you get error like this: The Amazon Redshift database encountered an error while running this que...
Using HTML and Liquid to create 'progress' bars inside a Table Vis
There are a number of great use cases for being able to have a progress bar or a way to visually represent whe...
Subtotals using Native Derived Tables and Templated Filters
We often hear requests to produce subtotals in Looker explores. Here’s a pattern to do that using Native Deriv...
Grouping by date types instead of strings
For queries that group by a date, keeping the column as a date is much faster than converting it to a string. ...
Joining Date to Datetime in model
I was hoping for some assistance on an error I’m receiving trying to build out my model. I currently have two ...
[Analytics Block] Customer Retention and Lifetime Value - Survival Style
Customer retention and value are some of the most analyzed metrics here at Looker and with our customers. Ther...
Example LookML Development Guidelines
This is one a approach you can use an example development guide. The goal of this list is provide some things ...
Symmetric Aggregates
The Problem A long standing limitation of SQL has been the asymmetry and complexity of its aggregate computati...
