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