Seasonal Sales Forecasting
Scenario In a related post, I illustrated a pattern that allows for some lightweight linear forecasting of mea...
Scenario In a related post, I illustrated a pattern that allows for some lightweight linear forecasting of mea...
Why would you need this article? When you have tables and table schemas that are constantly in flux, but still...
There is a table, for example Product / Order / Price A / 1 / $6 A / 2 / $11 A / 3 / $7 B / 4 / $8 B / 5 / $12...
The purpose of this article is to understand how to group by information in your database which is only availa...
Sequencing Transactions is a very common analytical pattern. In the example below, we will compute a sequence ...
Hi, I have this measure in a derived table : COALESCE(SUM(CASE WHEN ((DATE(sql_activity_days.sale_date )) - (D...
Often our business users want to change timeframes on the fly - our internal teams report in weekly cycles whi...
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...
As a Customer Success Engineer here at Looker, I’ve spent quite a bit of time working on a diverse set of mode...
Is there a way to use a free-text parameter in a fuzzy “LIKE” statement including wildcards? For example - I h...
About this BlockBigQuery allows for the creation of User Defined SQL function written in either SQL or Javascr...
A daily_usage table can be useful for summarizing usage per day. But what if there is a day without any usage ...
has anyone experienced the following error when using required_fields in a measure and then trying to pivot in...
Cumulative Sums are a little tricky in MySQL. The simplest way to tackle this would be to use the running_tota...
Hi all! Have you get error like this: The Amazon Redshift database encountered an error while running this que...
There are a number of great use cases for being able to have a progress bar or a way to visually represent whe...
We often hear requests to produce subtotals in Looker explores. Here’s a pattern to do that using Native Deriv...
For queries that group by a date, keeping the column as a date is much faster than converting it to a string. ...
I was hoping for some assistance on an error I’m receiving trying to build out my model. I currently have two ...
Customer retention and value are some of the most analyzed metrics here at Looker and with our customers. Ther...
This is one a approach you can use an example development guide. The goal of this list is provide some things ...
The Problem A long standing limitation of SQL has been the asymmetry and complexity of its aggregate computati...
At the AWS Summit on Wednesday, April 19th, 2017, Amazon announced a new Redshift feature called Spectrum. You...
Do you have date tables in your model? If so, you’ve probably noticed performance issues around them, but may ...
Introduction The entity-attribute-value (EAV) schema is often encountered in business tools where the number o...
Bi-Weekly timeframes can be really useful! For now, using SQL is the best way to achieve this. In Redshift, he...
Release 3.24 will come with the ability to extend Explores and Views. These are key features in building reusa...
In new LookML, the vast majority of parameters will be your old familiar friends. The new LookML IDE shows you...
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
For information on using Git with Looker, see this page in our documentation. Looker uses Git to manage versio...
