Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Count({<Volume = {'>=1<=10'} >} Assignments)
Works perfectly! Thanks Sunny!