Skip to main content
This is where you put your semantic layer to work day to day: run queries, build charts and dashboards, and share results with your team. You’ll find every chart type, filters and table calculations for shaping results, and the metrics catalog for browsing what’s available to query. Spaces keep your saved charts and dashboards organized, while alerts and scheduled deliveries push results to you and your team automatically, in Lightdash or over email and Slack.

Filters reference

How filters combine, plus every filter type and operator and the SQL each one compiles to

Search

Find charts, dashboards, spaces, tables, and fields anywhere in your project

Build charts

Configure your charts

Layout, series, axes, display, and data options shared by most chart types

Custom tooltips

Show extra metrics, notes, links, and custom HTML in chart tooltips using field variables

Using custom fields

Create custom dimensions and metrics on the fly for quick calculations and binning

Formatting your fields

Hide, group, relabel, and number-format your fields in YAML or in the UI

Period-over-period comparisons

Compare a metric against its previous period, and the ways Lightdash can calculate the shift

SQL runner

Build ad-hoc queries and charts with totally custom SQL

Merge queries

Combine two explores into one result by joining them on a shared field

Table calculations

Formula table calculations

Build table calculations using a spreadsheet-style formula syntax instead of raw SQL

Row functions

Built-in functions for accessing values from other rows in your table calculations

Pivot functions

Built-in functions for accessing values across pivot columns in your table calculations

Aggregate functions

Built-in functions for referencing column and row totals in your table calculations

SQL templates

7 pages

Dashboards

Interacting with dashboards

Filter, re-zoom, cross-filter, and drill into the charts on a dashboard without editing them

Dashboard filters

Filter every tile on a dashboard at once with temporary, saved, required, and URL filters

Date zoom

Change the time granularity of charts on your dashboard without editing them

Explore view

Filtering in the Explore view

Add filters from the Filters tab, the field sidebar, or the results table, and nest them into groups

Metrics catalog

Catalog

Browse, explore, and curate your metrics in the Metrics Catalog

Saved Trees

Build shareable diagrams that show how your metrics relate to each other

Drivers

Declare which metrics feed into another and see those relationships in Saved Trees

Organize and share

Spaces

Organize saved charts and dashboards into spaces, and manage who can access each one

Default user spaces

Give every eligible user a personal space, provisioned on their next login

Review requests

Submit charts and dashboards from your personal space for review, promotion, and verification

Homepage

Build and publish project homepages with curated blocks and audience-specific layouts

How to promote content

Copy charts and dashboards from a development or preview project into production

Verified charts and dashboards

Mark charts and dashboards as verified so your team can spot trusted content at a glance

Version history

Roll back to earlier versions of charts and dashboards in Lightdash

Sharing charts

Share a work-in-progress exploration or a saved chart, and download results and chart images

Scheduled deliveries

Send a dashboard or chart and its results to people on a schedule via email or Slack

Alerts

Get notified in email or Slack when a saved chart's values meet conditions you set