I will exemplify a hypothetical case that I think will be better understood. The company's activity is to detect water leaks. When a new client reports that he has a leak problem and requests the service of this company, the file number of this case is created, and a technician is sent to perform the intervention to detect the leak. Sometimes it happens that in the first intervention it is not detected correctly and it is necessary to make second or third visits (or whatever they are) to perform new interventions in search of this leak. Every time a technician goes to look for the same leak again, it is a new intervention but it corresponds to the same file. Therefore, the last intervention is considered successful only (since it has not gone again) and the previous ones failed with respect to the same file. This last intervention can be performed by the same technical care as the previous ones or not, and what I want to measure is the total number of successful interventions by each technician.
In the end, this company carries out thousands of interventions corresponding to thousands of files, I want to be able to measure precisely the successful interventions per technician and therefore also the failed ones. That is, I want to be able to see, for example, a table visualization with the names of the employees, and the number of successful and failed in any period of time.
Thank you very much again for the help you are giving me.
