Looker tips for users, developers and admins
Equally scaled table cell visualisations
Improving on Looker’s built-in table cell visualisation by enabling all series to use the same scale.
Enhance your Expression Editing
See how to write & edit complex Looker expressions more easily
Adding Images to Dashboards
How to add images to your Looker dashboards, and a tip for hosting them in Google Drive.
Field Picker Filtering
How the Looker Explore field picker’s search/filter feature makes it easy to find fields.
Looker Keyboard Shortcuts
A guide to keyboard shortcuts in Looker and some of the most useful.
Monitoring Looker
How to monitor the your Looker instance.
Undo & Redo in Explores
A handy trick in Looker Explores to give you undo and redo functionality.
Awesome API
A few examples of handy ways to use Looker’s API
Customised User Homepages
How to set up customised Markdown homepages For different groups of users
Substitution and sql_table_name
Requiring Field Usage
A clever way to make sure that users can’t run incorrect Explore queries and get some feedback if they try.
Conditionally Protecting PII
See how you can stop users from using certain fields together in a query which together could personally identify individuals.
Custom Timeframes for Dimension Groups
How to use SQL and LookML to define an arbitrary custom timeframe as part of a LookML dimension group.
if dev/if prod SQL conditionals
The if dev/if prod SQL conditionals for changing generated SQL for development and production mode.
Getting Creative with Constants
Some interesting ways to use LookML constants in your projects.
Row-wise MoM Calculations
How to use table calculations to calculate month-over-month changes based on rows of data for a nicely formatted result
Custom Code Folding
How to fold your LookML and SQL code in arbitrary places to keep your files organised and easy to navigate.
Clever Calculations
How to use expressions in Looker’s table calculations for precise control of the numbers for each column or the whole table.
Queries, History & Metadata
All about Looker’s query history metadata
Managing Multiple LookML Projects
Things to consider when working with multiple interdependent LookML projects.