set analysis for the filter

[Vittore8]

Hi, how can I find the maximum date from a column and subtract 3 days from it, the result should be

using set analysis

[Kushal_Chawda · Accepted solution]

@Vittore8  in filter you can us below calculated field

=aggr(only({<Date = {">=$(=Date(max(Date)-3))"}>}Date),Date)