Filters and Parameters

Add interactive filters to your dashboards to let users explore data dynamically.

Filter Types

Date Range

Filter data by date or time period. Supports preset ranges and custom date pickers.

Last 7 daysLast 30 daysThis monthCustom range

Single Select

Dropdown to select one value from a list of options. Best for mutually exclusive choices like region or product category.

Multi Select

Select multiple values to include in the filter. Shows checkboxes for each option.

Search / Typeahead

Text input with autocomplete suggestions. Best for dimensions with many values like customer names or product IDs.

Numeric Range

Slider or input fields for filtering numeric values. Supports min/max ranges.

Adding Dashboard Filters

  1. Open your dashboard in edit mode
  2. Click + Add Filter in the toolbar
  3. Select the dimension to filter on
  4. Choose the filter type (date, select, multi-select, etc.)
  5. Configure default values and display options
  6. Select which views the filter applies to (all or specific views)

Filter Configuration

{
  "filters": [
    {
      "name": "date_range",
      "label": "Date Range",
      "type": "date_range",
      "dimension": "order_date",
      "default": "last_30_days",
      "presets": ["last_7_days", "last_30_days", "this_month", "this_quarter"],
      "applies_to": "all"
    },
    {
      "name": "region",
      "label": "Region",
      "type": "multi_select",
      "dimension": "region",
      "default": [],
      "show_all_option": true,
      "applies_to": ["revenue-chart", "orders-table"]
    },
    {
      "name": "min_revenue",
      "label": "Minimum Revenue",
      "type": "numeric",
      "dimension": "revenue",
      "operator": ">=",
      "default": null
    }
  ]
}

Filter Behavior

Cascading Filters

Enable cascading to update filter options based on other selections. For example, selecting a region updates the city dropdown to show only cities in that region.

URL Parameters

Filter values are reflected in the URL, allowing you to share filtered views with direct links.

/dashboards/sales?date_range=last_30_days&region=North,South

Cross-filtering

Click on chart elements to filter the entire dashboard. For example, clicking a bar in a bar chart filters all other views to that category.

View-Level Filters

In addition to dashboard-level filters, each view can have its own hardcoded filters:

{
  "id": "active-customers-chart",
  "title": "Active Customers",
  "chart_type": "line",
  "metric": "active_users",
  "filters": [
    {"field": "status", "operator": "=", "value": "active"},
    {"field": "signup_date", "operator": ">=", "value": "-90 days"}
  ]
}

View-level filters are always applied and cannot be changed by dashboard users.

Parameters

Parameters allow users to modify calculations, not just filter data:

{
  "parameters": [
    {
      "name": "growth_target",
      "label": "Growth Target %",
      "type": "number",
      "default": 10,
      "min": 0,
      "max": 100
    },
    {
      "name": "comparison_period",
      "label": "Compare to",
      "type": "select",
      "options": ["Previous Period", "Same Period Last Year"],
      "default": "Previous Period"
    }
  ]
}

Use parameters in metric expressions: revenue * (1 + @growth_target / 100)