Forum Discussion
Count consecutives based on an Criteria
Hello, i would like to count the number of Events that are out of especificacion (IN = 0, OUT = 1), based on time and criteria,
For example My variable has criteria for every 3 points out, should be an anomaly, but if is for example 10 consecuite points out, it should also count as 1 anomaly,
VARIABLE
| FECHA | HORA I | HORA F | IN = 1, OUT = 0 | CRITERIA | |
| 1/02/2021 | 00:00 | 08:00 | 2.09 | 0 | 3 |
| 1/02/2021 | 08:00 | 16:00 | 3.33 | 0 | 3 |
| 1/02/2021 | 16:00 | 00:00 | 2.13 | 0 | 3 |
| 2/02/2021 | 00:00 | 08:00 | 4.34 | 1 | 3 |
| 2/02/2021 | 08:00 | 16:00 | 3.29 | 0 | 3 |
| 2/02/2021 | 16:00 | 00:00 | 8.81 | 1 | 3 |
| 3/02/2021 | 00:00 | 08:00 | 9.37 | 1 | 3 |
| 3/02/2021 | 08:00 | 16:00 | 5.37 | 1 | 3 |
