Use filters to make your dashboards dynamic and interactive
Filters allow you to create dynamic, interactive dashboards that adapt to user selections and time ranges. They work at the dashboard level and automatically inject values into your chart queries, making it easy to explore different data slices without rewriting prompts.
Filters are dashboard-level controls that automatically add variables to your chart queries. When you reference entities or time periods in your prompts, Basedash intelligently creates the appropriate filters and injects them into your SQL queries.
Basedash supports six different filter types that you can use to create dynamic, interactive dashboards. Each type serves a specific purpose and provides different functionality.
Record filters allow you to select specific records from your database tables. They’re perfect for entity-level dashboards where you want to focus on individual records.Features:
A dropdown that provides preset time intervals (e.g., daily, weekly, monthly) for consistent time-based analysis.These built-in filters are automatically created when you reference time-based analysis in your prompts and can be used across multiple charts on the same dashboard.
You can view and manage all filters for a dashboard by going to the Variables tab within the full-screen code editor. This shows all filters with their current values and allows you to modify filter configurations.
When you hover over a filter on a dashboard, charts that use that filter will be highlighted, making it easy to see which charts are affected by each filter.