Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Strooprover
Contributor
Contributor

Count between values aggregated for days

Hi,

 

I have a dataset where I have the lines when a article has been sold.
I would like to make a set expressions in which I count the amount of days where an article has more than 2 lines and less than 5 lines. In this case this should lead to the result of 2.

Can anyone help me with a set expression which would make this calculation?

DateArticleAmount
21-3-20211231
21-3-20211231
21-3-20211235
22-3-20211232
22-3-20211231
22-3-20211232
23-3-20211231

 

Much thanks in advance!

1 Reply
QFabian
Specialist III
Specialist III

Hi @Strooprover , please check if this is what you want :

 

OP1 :

=count(if(Amount >=2 and Amount <5,Date))

OP2 :

=count({<Amount = {">=2<5"} >} Date)

QFabian