Warehouse data and dashboards

Refresh a dashboard on a schedule

Run a dashboard's warehouse queries every hour, day or week, keep the answers for every reader, and pause, turn off or run the refresh now.

On this page

A refresh runs a dashboard's live warehouse queries on a schedule and keeps the answers. Everyone who opens the dashboard then sees those answers at once, marked As of and the time they ran, without waiting for the warehouse.

When to use it

  • Many people open the dashboard, and the figures need to be current to the hour, day or week, not to the second.
  • The queries are slow or cost money in the warehouse each time they run.

A refresh runs the live warehouse tiles only. Tiles over saved data don't change, and tiles under your data rules always run for each reader.

Set the schedule

  1. Open the dashboard and choose Refresh schedule in its header.
  2. Under How often, choose Hourly, Daily or Weekly. For daily and weekly, choose the time, and the day for weekly, and the time zone.
  3. Choose Save.
  4. Open the refresh again from the header and choose Turn on. Until someone does, nothing runs.

The header then says how it runs, such as Refreshes every day at 07:00 as Ana · last run 07:02. Choose that line to change the schedule.

You can also ask in the chat, for example "Refresh this dashboard every morning at 7". Ahamo sets the schedule and turns it on as you.

Setting the schedule needs permission to edit the dashboard.

Who it runs as

A refresh runs as the person who turned it on, with their access to the warehouse, and their warehouse costs. Everyone who opens the dashboard sees those answers, even people who couldn't run the queries themselves. Turn it on only when that is right for everyone you share the dashboard with.

A reader whose filters are at their defaults sees the kept answer. A reader who picks other filters gets a live run, as themselves. So ask for a moving period inside the query, such as the last 30 days, rather than as a filter.

After each refresh, Ahamo works out the number tiles that use the refreshed answers again, and checks them again, without AI. If that fails, the number keeps its last figure and says Out of date, with when it was worked out.

When it pauses

A refresh pauses by itself, and nothing runs, when:

  • anyone changes a query after it was turned on. Turn on again runs the queries as they are now, as you;
  • it fails twice in a row;
  • the person it runs as can no longer edit the dashboard. Turn on again runs it as you.

A paused refresh that waits on you is listed under Needs you on Home and in Library › Routines.

Turn it off, remove it or run it now

  • Turn off stops it and keeps its schedule. Turn on again starts it, as you.
  • Remove schedule deletes the schedule.
  • Run now runs a refresh that is on, straight away, as the person it runs as. It's on the refresh's row in Library › Routines.

Every dashboard refresh is listed in Library › Routines beside your other routines, named after the dashboard, with whom it runs as, its last run and the same actions. A refresh that is off is listed under Paused as Off. See Run work on a schedule with routines.

Troubleshooting

A query changed since the refresh was turned on, so it's paused. Check the queries, then choose Turn on again.

The refresh failed twice in a row, so it's paused. The reason is shown with it. Fix the query or the connection, then choose Turn on again.

It's paused. Turn it on again first. Run now works only on a refresh that is on.

Nobody has turned it on yet. The schedule is saved, but nothing runs until someone who may edit the dashboard chooses Turn on.

A build is running on this dashboard. Try again when it ends. Wait until the chat's work on the dashboard ends.

Numbers wait for the next refresh, because the App was busy. The figures are worked out again after the next refresh.

On this page