Hi!I have table:
DATE | ID | RATING |
2020-12-01 | 10 | 1 |
2020-12-03 | 13 | 2 |
2020-12-03 | 10 | 3 |
2020-12-05 | 11 | 2 |
2020-12-01 | 15 | 3 |
2020-12-03 | 13 | 5 |
2020-12-03 | 15 | 5 |
2020-12-05 | 10 | 4 |
and i want add table like this:
DATE | COUNT_RATING100 |
2020-10 | 645 |
2020-11 | 725 |
2020-12 | 57 |
COUNT_RATING100 = SUM (Aggr (IF (Count([RATING])>='100',1,0 [ID])
If I filter by date(month), I have like this:
DATE | COUNT_RATING100 |
2020-11 | 5648 |
and that true
I dont know why COUNT_RATING100 is considered incorrect in first example
help