Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I used a set analysis to capture the next date on column "Next Repair Date" using script =DATE(MIN({<[Next Repair Date] = {">=$(=TODAY())"}>} [Next Repair Date])). Next I stored the expression in a variable and used another set analysis to capture column "Car Repair Maintenance Service" based off of the Next Repair Date set analysis using =only({<Date={'$(=$(NextRepair))'}>} [Car Repair Maintenance Service]). However, I get nothing when I apply this expression. What is causing my set analysis to not capture any data? It show capture data Engine Modifications based off this script.
Sample Data Below
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 |
Try below
=only(
{< NextRepairDate ={'$(=MIN(total {<[NextRepairDate] = {">=$(=TODAY())"}>} [NextRepairDate]))'}
>} CarRepairMaintenanceService )
OR
Change the variable definition as below
NextRepair =MIN({<[Next Repair Date] = {">=$(=TODAY())"}>} [Next Repair Date])
Measure :
only(
{< NextRepairDate ={'$(=NextRepair)'}
>} CarRepairMaintenanceService )
Try below
=only(
{< NextRepairDate ={'$(=MIN(total {<[NextRepairDate] = {">=$(=TODAY())"}>} [NextRepairDate]))'}
>} CarRepairMaintenanceService )
OR
Change the variable definition as below
NextRepair =MIN({<[Next Repair Date] = {">=$(=TODAY())"}>} [Next Repair Date])
Measure :
only(
{< NextRepairDate ={'$(=NextRepair)'}
>} CarRepairMaintenanceService )