Hello Community,
I am trying to get values in a table sorted in intervals with statements.
Below is sample data, the Count(Assignments) and Count({<Volume = {'>=10'} >} Assignments) works well enough, but what i need is to have multiple intervals showing different volume values. That I can't get to work..
| Country | Count(Assignments) | Count({<Volume = {'>=10'} >} Assignments) | Volume interval 1 - 10 | Volume interval 11-50 | Volume interval 51-100 |
| SE | 100 | 10 | |
| DE | 200 | 20 | |
| US | 100 | 10 | |
| FR | 200 | 20 | |
I was thinking that it needs to be an IF statement or some variation of the Count statement.
Example: Count({<Volume = {'>=1' and '<=10'} >} Assignments) - but that did not work
