Hello,
I have a set analysis based on the next date after today. =DATE(MIN({<[Next Repair Date] = {">=$(=TODAY())"}>} [Next Repair Date])) and I get 10/25/2022 as the date selected. The next step I am trying to figure out is how to create a set analysis based on 10/25/2022 so I can obtain other data such as "Repair Plan" and "Car Repair Maintenance Service". For Repair Plan and Car Repair Maintenance based off of 10/25/2022 from column Next Repair Date I should be able to obtain data result "Planned" and "Engine Modifications". What set analysis script would be best for obtaining that result?
Sample data below for reference.
| Car VIN Number |
Next Repair Date |
Manufacturer Date |
Log Complex |
Field Team Name |
Repair Plan |
Car Repair Maintenance Service |
| |
|
|
|
|
|
|
| 9000000405 |
5/28/1945 |
3/16/2021 |
OC |
CON |
Planned |
Modification |
| 9000000405 |
11/6/2035 |
5/28/2013 |
OC |
CON |
Planned |
Modification |
| 9000000405 |
11/10/2022 |
11/16/2010 |
OC |
CON |
Planned |
Modification |
| 9000000405 |
10/25/2022 |
11/6/2012 |
OC |
CON |
Planned |
Engine Modifications |
| 9000000405 |
10/28/2022 |
- |
SA |
ORG |
- |
Full Service |
| 9000000405 |
12/25/2022 |
- |
SA |
ORG |
- |
Engine Modifications |
