Global Filter: Single Value select Option with custom SQL

Hi Arcadia Team

I have a global filter in dashboard which is based on a daily snapshot partition key (as_of_date).

This filter is a single value selection using Radio button.

Is there a way to select max(as_of_date) from dataset as the default value selection whenever the dashboard is loaded?