We are using internally a dashboard for monitoring real time performance of our countries. I have basically 60 users looking at this dashboard everyday with an auto refresh setup at 15 minutes. The issue here is that auto refresh forces the dashboard to update (bypassing any caching policy) and therefore, we are sending a huge amount of queries to BigQuery resulting in a nice scanning bill!
I would ilke to try to find a solution to deactivate the auto refresh on this dashboard and trigger the update every 15minutes only once so that all users see the most recent version of the data without reloading their browsers. What would be the approach to do so? Is there a method with the Looker API to trigger a dashboard refresh or something like this?
Thanks for your help,