Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

set analysis for the filter

Vittore8_0-1599382724429.png

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

Vittore8_1-1599382894286.png

using set analysis

 

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@Vittore8  in filter you can us below calculated field

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

View solution in original post

1 Reply
Kushal_Chawda

@Vittore8  in filter you can us below calculated field

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