Query Filters

Production - Dynamic filtering, filter presets, cross-widget filtering

The Filter system provides dynamic query filtering capabilities for dashboards and reports. Filters can be applied across multiple widgets and persisted as presets.

12.4.5.1Filter Types

Filter Type	Description	Example
`date_range`	Date/time range selection	Last 30 days, Q4 2024
`select`	Single value selection	Region = "EMEA"
`multi_select`	Multiple value selection	Regions in ["EMEA", "APAC"]
`numeric_range`	Numeric range	Revenue between $1K and$ 100K
`search`	Text search/contains	Customer name contains "tech"

# Add filter to dashboard
curl -X POST http://localhost:8000/api/v1/bi/dashboards/{dashboard_id}/filters \
  -H "Content-Type: application/json" \
  -H "X-Tenant-ID: acme-corp" \
  -d '{
    "name": "Date Range",
    "filter_type": "date_range",
    "column": "order_date",
    "default_value": {"start": "2024-10-01", "end": "2024-12-31"},
    "apply_to_widgets": ["widget-1", "widget-2", "widget-3"]
  }'

Data Export Report Scheduling