I need a dashboard with several similar reports based on the same query, which differ only in (static) parameters.
The data changes regularly, so the query has a refresh schedule.
In the dashboard I have inserted a visualization with different static parameters several times. This works very well so far and is exactly what I want.
When the dashboard is called, there is always very old data in the graphs (From the time of the last manual refresh). Until someone presses refresh again. Since the dashboard runs unattended on a TV, this is very inconvenient.
The alternative is to simply create the query multiple times without parameters and to write the SQL code accordingly. But then you have to edit x queries when changes occur, which is very annoying and unmanageable.
My wish would be, that when you open a dashboard, it checks, if the cached data is older than the refresh schedule and if so, the query is executed again with these (static) parameters.
I use version 8.0.0+b32245.