Update reports to latest date automatically
I have a set of dashboards for which the data is each business day. I'd like for the reports to update to the most recent data on loading but I don't seem able to achieve this.
I cannot use yesterday as the data is not updated on the weekends.
I know I can use max date, but that converts the filter into a dropdown, instead of a date picker -which is a date picker.