In the database we mark rows with the "Error" label - if an error has been made, the test as a whole is invalid. This should be clearly indicated in R Shiny, and for comparison, invalid tests should be filtered out. In the future we might also want to use tests which has rows with "Error" labels, to also understand how many attempts someone needed before they could complete a test properly.
Use a summary that clearly shows the success to error ratio (fx 20 hits total (19 Success / 1 Invalid).
Color the test in the test details view red, if the test has errors.
Filter out tests with invalid hits, in the "Compare Tests" view.
In the database we mark rows with the "Error" label - if an error has been made, the test as a whole is invalid. This should be clearly indicated in R Shiny, and for comparison, invalid tests should be filtered out. In the future we might also want to use tests which has rows with "Error" labels, to also understand how many attempts someone needed before they could complete a test properly.