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

    Count values in an interval function

    Oskar Madenteg

      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
      SE10010
      DE20020
      US10010
      FR20020

       

      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