Dashboard Filters: How to set them dynamically?

[ramonvermeulen]

We are having a dashboard with two filters of type date:

• Report Date
  Is there a way to by default put this on the last business day (e.g. if you open the report on a monday, it should be the last friday. If you open the report on a wednesday, it should be (yesterday) tuesday)
  OR
  If it is easier to implement, is there a way to put it to the max(date) available in the data of an explore?
• Comparison Date
  Is there a way to update this filter when someone selects a Report Date. E.g. ideally we would like this filter to be the second last business day as default when you open the report. But then when you select a different Report Date that the value of this filter will change the the first business day before the Report Date. After that you can still change this Comparison Date in case you want to compare some other date with the current Report Date.

I am talking about these type of filters: https://cloud.google.com/looker/docs/reference/param-lookml-dashboard#filters-for-dashboard

Any suggestions on how to make this possible in a LookML dashboard? Would be highly appreciated!