Hey Joseph -
- Nest the visualization/dashboard in a web page
- In the web page, write a few lines of code that automatically turns auto-update off when the dashboard finishes rendering.
Or, go "quick and dirty" and add a big orange label to the dashboard that says "Don't forget to turn off auto-update!"
Seriously, they'll figure it out after having to wait a few times
I accomplish something similar, although not exactly what you want. I have a "Report state" parameter set to "Paused" which I include in a filter so that the underlying query loads no data. The dashboard/worksheet opens immediately. The user changes all the filters/parameter and then sets the "Report state" parameter to "Active." By setting the parameter to Active, the query returns data.
select * from table where 'Active'=<Parameter.Report state>