Set Analysis Based on Date for KPI Designer

[griffin2571]

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