Change in JSON Render Formatting (6.22+)
In Looker 6.22, Looker’s method for rendering values in some JSON formats for sending, scheduling, and downloa...
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
Best way to cast from string to number - BigQuery
Hi All! I have a number in my bq-table that is stored as a string with this format “123.00-” or “123.00+”. I n...
[Partner Block] Event Analytics by Segment
What is this Block and what does it tell me? Segment is a customer data hub that allows customers to track dat...
List Of Values
Hi Could anyone please tell me how we can assign a list of values (either static values or through custom SQL)...
Is Counting a Boolean (Yes/No) Measure possible?
Good evening looker fam! 酪 I am currently trying to find a way to display and visualize the aggregate/total ...
Liquid in SQL statement for derived table
I am just wondering if this is possible: view: finance_services { derived_table: { sql: {% if parameter.locale...
Parsing user agent into device_type, manufacturer, browser
I’m currently using a fairly rudimentary case statement to parse useragent strings into ‘device_type’ (see bel...
[Analytic Block] Cohorting Users by Creation Date and Order Transactions
Analytic BlockAbout This Block Evaluating customer behavior over time can provide a number of insights into th...
[Analytic Block] Retention Analysis
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
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...
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...
