You can configure OpenLIT dashboards to automatically refresh data at set intervals. This feature is essential for live monitoring dashboards, status boards, and any view that requires up-to-date metrics from ClickHouse.

​
Why use refresh intervals?

Refresh intervals allow you to:
  • Keep data fresh without manual reloads and automatically re-run queries behind the scenes
  • Power live dashboards for operations and support teams
  • Monitor real-time metrics

​
How to enable auto-refresh

Once set, the dashboard will automatically re-fetch data from ClickHouse at the selected interval.

​
Available refresh rate

IntervalUse Case
NeverStatic dashboards
30 secondsLive dashboards, production stats
1 minuteStandard monitoring (default)
5 minutesLow-frequency updates
10 minutesLess load on db

​
Available time intervals

RangeDescriptionExample Use Case
24HLast 24 hours from nowReal-time metrics, active users, API logs
7DLast 7 calendar daysWeekly trends, retention, issue tracking
1MLast 1 calendar monthRevenue analysis, product adoption
3MLast 3 calendar monthsQuarterly metrics, strategic reviews
CustomSelect any start and end date manuallyAudits, investigations, historical views
Snippet to make use of the time interval in the query: 
WHERE event_time BETWEEN {{filter.timeLimit.start}} AND {{filter.timeLimit.end}}
Use shorter intervals only for optimized queries. Long-running queries + high refresh rates can overload your ClickHouse backend.

​
Best practices

  • Use dynamic bindings like {{filter.timeLimit.start}}, {{filter.timeLimit.end}} to make your chart respond to dashboard time filters.
  • Avoid using LIMIT 1000 or wide result sets on high-frequency updates
  • Use refresh intervals in combination with pinned dashboards for kiosk or ops setups