How To
- 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
- Subtotals with Table Calculations
- 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
- Sorting Pivots
- Parameterizing Filters with User Attributes
- How to Calculate Percent-of-Total
- How to Make Conditional Value Formats for Large Numbers
- How to do Period-over-Period Analysis
- Computing the Difference Between Dates (for Non-Developers)