Do those attempts carry a stable plate identity across restart? If they only share a job name, counting distinct rows won't answer how many physical plates you have.
Then show attempts separately and derive accepted plates from the authorised disposition for each plate. A pass row on its own may not be the current decision if another check was reviewed afterwards.
Hazel, worth spelling out what happens when a reviewed fail follows a pass. A simple 'has ever passed' filter would make the number prettier and still wrong.
Reconcile the rest of the physical batch as well. Accepted, awaiting a decision and rejected should account for the plates, while the attempt total can legitimately be larger.
Have they tested the rebuilt count through restart and a changed authorised disposition? Reproducing today's export alone won't expose the old counter incrementing again.
Yes. Restart replay stays at 224; changing one accepted test plate to reviewed fail reduces the test total to 223. Its attempts remain visible. Installed dashboard reconciled to the unchanged batch at 224.