2 Replies Latest reply: Mar 22, 2017 5:57 AM by Oskar Madenteg RSS

    Count values in an interval function

      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..


      CountryCount(Assignments)Count({<Volume = {'>=10'} >} Assignments)Volume interval 1 - 10Volume interval 11-50Volume interval 51-100


      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