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, or browse them from the home page

Chart types

Bar chart

Use bar charts to compare things between different groups or track how a number changes over time

Line chart

Use line charts to show changes in a number over a short or long period of time

Area chart

Use area charts to show how values develop over time when the total is as important as its parts

Mixed chart

Use mixed charts to combine bars, lines, and scatter charts on the same visualization

Scatter chart

Use scatter charts to look at the relationship or correlation between two variables

Pie chart

Use pie charts to visualize data that adds up to a meaningful whole

Funnel chart

Use funnel charts to show pipeline performance, product conversion metrics, or any process with discrete stages

Treemap chart

Use treemap charts to show parts of a whole using nested rectangles

Sankey chart

Use Sankey charts to visualize flows between categories, showing how values move from sources to targets

Table

Use tables for looking at tabular data or lists of things like user IDs or transactions

Big value

Use big value charts to display a single value prominently

Gauge

Use gauges to highlight a single value against a qualitative range, like performance against a target

Map

Use maps to display geographic data on an interactive map

Custom Vega charts

One-off charts written as a Vega-Lite spec in a JSON editor, plus worked templates you can copy

Custom project charts

Reusable chart types you build once for your project, then use like any built-in chart type

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 format metrics and table calculations 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

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

Define which metrics influence each other in your .yml files and visualize 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 their own personal space in a project, provisioned automatically on their next login

Pinning content

Pin spaces, dashboards, and charts to the homepage so your team sees them first

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