Dashboards

Filters & Variables

Add interactive controls to dashboards so viewers can explore data without writing SQL.

Dashboard filters

Filters appear at the top of a dashboard and affect all charts that reference the filtered column. Add a filter from the dashboard edit toolbar → Add Filter. Supported types: date range picker, dropdown, free text, and number range.

Connecting filters to queries

Use double-brace syntax in queries to reference filter variables:

sql

SELECT date, sum(revenue) as total
FROM orders
WHERE DATE(created_at) BETWEEN {{start_date}} AND {{end_date}}
GROUP BY 1

Chart Types

Sharing