Count values in an interval function

Wed, 22 Dec 2021 15:42:54 GMT

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

Re: Count values in an interval function

sunny_talwar — Wed, 22 Mar 2017 09:54:34 GMT

Try this

Count({<Volume = {'>=1<=10'} >} Assignments)

Re: Count values in an interval function

Wed, 22 Mar 2017 09:57:42 GMT

Works perfectly! Thanks Sunny!

topic Re: Count values in an interval function in App Development

Count values in an interval function

Re: Count values in an interval function

Re: Count values in an interval function