[Analytic Block] Tags and Attributes (with and without Arrays)
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
How to use Git in Looker
For information on using Git with Looker, see this page in our documentation. Looker uses Git to manage versio...
[RETIRED] How can I use compound primary keys in Looker?
The content of this article can be found in Looker’s technical documentation here.
[Analytic Block] BigQuery Table Date Range (Deprecated)
This method has been Deprecated, this method only works with Legacy SQL, Standard SQL is recommended. ##About ...
Using sql runner to test derived tables
To learn about SQL Runner, see this document page and choose release 4.16 or higher. If you see an error comin...
Using Google Images API in Looker
Adding images to your Looks and dashboards looks great, and is easy to do with the html LookML parameter. In t...
Distance between latitude/longitude coordinate pairs
##Howdy Good Lookers! ###Lucky for you Looker now has a built-in distance dimension that supports this use cas...
Best practices for excluding erroring fields from explores
I have run into the following situation a bunch of times, and it feels like a best practices recommendation of...
Using HTML and Liquid with Looker
What is Liquid? Liquid formatting is an open source Ruby-based template language built by Shopify (Liquid Docu...
Creating a type count measure for non-primary keys
###Quick Intro Looker natively translates a type: count measure into a COUNT(*). The sql: parameter has no eff...
Drill using a sparkline or other images
###Objective Add a nice sparkline to encourage users to link out to wherever the sparkline points. I’ve most o...
[Analytic Block] Sequencing Transactions
##About This Block Nearly all businesses want customers to come back. It’s often much easier to increase your ...
[Analytic Block] Derived Tables Pattern
About This Block Often times our database doesn’t store information optimally for analytics. Rather than writi...
[Analytic Block] Repeat Purchase Patterns
About This Block Repeat business is the key to success for most ecommerce companies. Figuring out behavioural ...
[Analytic Block] Creating Custom Cohort Analysis
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
