Hello
Please look at the example to better understand my question.
I want to do a sum(count) of the number of errors per section. The sections are reoccurring over time.
DATA:
| ID | Date | section | number of errors in section |
| 1 | 1 | A | 1 |
| 2 | 1 | A | 1 |
| 3 | 1 | A | 1 |
| 4 | 1 | A | 1 |
| 5 | 1 | A | 1 |
| 6 | 1 | B | 0 |
| 7 | 1 | B | 0 |
| 8 | 1 | B | 0 |
| 9 | 1 | C | 2 |
| 10 | 1 | C | 2 |
| 11 | 1 | C | 2 |
| 12 | 1 | C | 2 |
| 13 | 2 | A | 0 |
| 14 | 2 | A | 0 |
| 15 | 2 | A | 0 |
| 16 | 2 | B | 2 |
| 17 | 2 | B | 2 |
| 18 | 2 | B | 2 |
| 19 | 2 | B | 2 |
| 20 | 2 | C | 1 |
| 21 | 2 | C | 1 |
| 22 | 2 | C | 1 |
| 23 | 2 | C | 1 |
TABLE that I want to produce
| section | errors |
| A | 1 |
| B | 2 |
| C | 3 |
| total | 6 |
I hope someone can help me with this.
.png "abeyphilip"){kind=avatar}
