What are filters?
Filters are interactive controls (e.g. date ranges) placed at the top of a dashboard. You can bind these filters to your widgets so their values get passed into SQL queries in real time.What are dynamic bindings?
OpenLIT uses mustache-style bindings to inject filter values into your queries.Format:
Common examples:
{{filter.timeLimit.start}}
and{{filter.timeLimit.end}}
— for date range filters
How to add and use filters
SQL example with mustache bindings
{{filter.timeLimit.start}}
&{{filter.timeLimit.end}}
are bound to a date range filter
Supported filter types
- Date Range →
{{filter.timeLimit.start}}
,{{filter.timeLimit.end}}
- (Coming soon): Dynamic filters etc
Best practices
- Always use meaningful keys like
team_id
,env
, orregion
- Use
coalesce({{param}}, 'default')
to provide fallback values in ClickHouse - Test your queries in the SQL editor with example values for clarity
- Avoid hardcoded constraints—use bindings to keep dashboards flexible