Development
Writing LookML and SQL, and how to solve problems and troubleshoot errors.
Explores and Joins
- Converting Shapefiles to TopoJSON
- Splitting Strings into Rows in the Absence of Table-Generating Functions
- Uploading Spreadsheet (Excel, Google Sheets) Data into Looker
- Why Aren’t My Measures Coming Through a Join?
- A Cure For the one_to_many Blues
- Nested Data in BigQuery (Repeated Records)
Extending LookML
Parameters and Templated Filters
- Dynamically Select Fields Using Parameters
- Filtering a View Using a Field from Another View without Joining Views
- Create a Dynamic Dashboard Image with Liquid HTML
- Masking Sensitive Fields for All Users
- Aggregate Awareness using _in_query
- Templated Filters and Derived Tables
Derived Tables
- Aggregate Awareness Tutorial
- How to "Dimensionalize" a Measure in Looker
- Sharing Datagroups across Model Files
- PDT Trigger Value: Rebuild multiple times per day
- Improving PDT Performance
- Using datagroups with Cascading PDTs
Dimension and Measures
- Using Liquid Split and Array Filters to Format Lists
- Using Liquid Variables in Aggregate Measures
- Week Ending Vs. Week Beginning
- Why Are My Fields with Division Showing Up as 0?
- Error: Non-Unique value/primary key Error
- Variable Reference Lines for Charts
Projects and Version Control
- Git Deployment Strategies with Looker
- Using Cloud Source Repositories for Version Control in Looker
- Converting .strings files to .strings.json files
- Connecting a New LookML Project to a Non-Empty Git Repository
- Setting up Phabricator and Looker for Version Control
- Using BitBucket for Version Control in Looker
Models
Troubleshooting
- Looker Liquid syntax parser
- Error: Measures with Looker Aggregations (Sum, Average, Min, Max, List Types) May Not Reference Other Measures
- Error: Column <name> must appear in the GROUP BY clause or be used in an aggregate function
- Error: Non-Unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum
- Factors Impacting Query Performance
- Why Aren’t My Measures Coming Through a Join?
Patterns
- The problem of SQL fanouts
- Methods for Period Over Period (PoP) Analysis in Looker
- Sort by Pivots, Rank with Other Bucket, and Percentile Tail Analysis
- Calculating Simple Monthly Recurring Revenue (MRR)
- [Analytic Block] Retention Analysis
- [Analytic Block] AB Testing with Statistical Significance