Skip to main content
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