How To
- Getting the First Record with a Non-Null Value in a Pivot Column or Pivot Row
- How to Find the Top Performers Over Time with Table Calculations
- Interactive Map Visualizations (3.34+)
- Best Practice: Optimize Query Performance
- Rolling Average Using offset_list in Table Calculations
- How to Sort by One or More Columns
- Creating Reference Lines for Charts through the Visualization Editor
- Looker-Built Google Sheets Import Script
- Reverse Running Totals
- Linear Extrapolation in Table Calcs (Forecasting)
- How to Count Only Weekdays Between Two Dates
- How to use Google Spreadsheets to Input Data into Looker
- Using Postgres and JSON Functions and Operators to Parse JSON Fields
- [Analytic Block] Daily, Weekly, Monthly Active Users
- Comparing a Previous Week to that Same Week Last Year
- Using the History Explore in the i__looker Model
- Performance Overview
- Best Practices when Updating your Looker Instance
- Subtotals with Table Calculations
- [Analytic Block] Flexible Period-over-Period Analysis
- Using offset and pivot_offset in Table Calculations
- Aggregating Across Rows (Row Totals) in Table Calculations
- Conditional Formating using Table Calculations
- [Analytic Block] Creating Custom Cohort Analysis
- Vertical Reference Lines
- Creating a Running Total Down Columns with Table Calculations
- How to Optimize SQL with EXPLAIN
- [Analytic Block] Dynamic Previous Period Analysis using date_start, date_end
- Calculating Percent of Previous and Percent Change with Table Calculations
- Best Practice: Visualize Data Effectively