Hi Hive mind
I have made a BAQ and dashboard that shows Received Po’s and added ship date to it which has slowed it down, it works but its slow, is there a way to not have my dashboard retrieve data until a date range is added. Just trying to speed up things when members of staff open the dashboard.
In the Dashboard Editor, in the Query Properties section, there is a setting ‘Auto Refresh on Load’
If you uncheck this box, the data from the query will not load until the user clicks the Refresh or Refresh All buttons. They can set their date range ahead of time.
Hi Dean,
In addition to Garret suggestion to not allow auto refresh on load… I like to use parameters on the BAQ as a quick means of forcing a filter entry prior to run of dashboard. You can also use a tracker view and pass the date, but the BAQ parameter is really a nice quick way to get it in there IMO.
Nancy
You can also add a tracker view with filters, and select Criteria Required.