Try setting an app formula condition for the [Fixed?] column itself in the Reports Table to automatically change the status to fixed if the most recent entry is set to fixed.
APP FORMULA EQUATION FOR THE [FIXED?] COLUMN IN THE REPORTS TABLE
IF(LOOKUP(MAXROW(“Report Table”,“TimeStamp”,[Equipment]=[_THISROW].[Equipment]),“Report Table”,“ID”,“Fixed?”)=TRUE,TRUE,[Fixed?])
Basically, (1) We find the most recent record for that vehicle (MAXROW). (2) We look up if it has been fixed or not (value of [Fixed?] column sing LOOKUP). (3) If it has been fixed, we set this entry (row) to fixed as well (so it will not show up in the slice because all reports are labeled “fixed” at the same time). (4) If it has not been fixed, we keep the current value that has been set for this entry (row).
The only potential pitfall I can see is if different problems were reported for the same equipment. The most recent problem might have been fixed because it was visible to the mechanic, but the problem reported earlier may not have been addressed? Depends on your work flow; if checks are daily, this may not be a problem because the original problem would be reflagged? We may have to play with your data set-up if this is a problem.
IF - IF(
…IF CONDITION (if the most recent entry for this equipment is fixed):
… … LOOKUP
… … LOOK UP VALUE (the most recent report for this equipment - MAX ROW automatically returns the value from the KEY column, so that’s what we’ll be looking up)
… … TABLE IN WHICH TO MATCH VALUE (the reports table - yes, it is referencing its own table)
… … COLUMN IN WHICH TO MATCH VALUE (name of the KEY column)
… … COLUMN TO GET VALUE FROM (name of the [Fixed?] column)
… … EQUALS TRUE (most recent entry for that equipment has TRUE in the [Fixed?] column)
… VALUE IF CONDITION IS TRUE (most recent entry HAS been fixed)
… … SET THIS COLUMN TO TRUE (report automatically also marked as fixed)
… VALUE IF CONDITION IS FALSE (most recent entry has NOT been fixed)
… … USE EXISTING COLUMN VALUE (use whatever is already selected)