Skip to main content
Auto-refresh is designed for situations where a dashboard needs to stay up-to-date on its own, such as when it’s displayed on an office TV. It automatically reruns your queries at a set interval so the dashboard always shows the latest available results.

​
Enabling auto-refresh

In a draft dashboard, navigate to Edit > Dashboard settings and toggle Auto-refresh to on. Use the Refresh every dropdown to select a time interval. The selected interval determines when the dashboard refreshes from the time it is opened to when it’s closed in the browser. For example, if set to refresh every 60 minutes and the dashboard is opened at 9:36AM, the queries will automatically run again at 10:36AM if the dashboard is kept open.

​
Understanding potential performance impacts

Auto-refreshed queries do not return from the cache. As such, consider the following when using auto-refresh to avoid affecting the performance of your database: To avoid affecting the performance of your database, consider the following when using auto-refresh:
  • How often this feature is used, specifically the number of dashboards and frequency of refresh, and
  • How performant the dashboard is, including the number of queries and runtime of each query
For example, you have a sales dashboard with 15 charts set to auto-refresh every 5 minutes. If this dashboard displays on a screen in four office locations, this would result in 60 queries running on your database every five minutes. Though auto-refresh itself does not use cache, the results from an auto-refresh triggered query can be used as cache for valid queries run manually elsewhere in Omni.