Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i count >=20 and <=40 in bar chart expression

How can i count >=20 and <=40 in bar chart expression

count({<Sum(Input31+Input32+Input33+Input34+Input35)={'>=20','<=40'}>} Name)

1 Reply
MK_QSL
MVP
MVP

=COUNT(Aggr(DISTINCT IF(SUM(Input31 + Input32 + Input33) >= 20 and  SUM(Input31 + Input32 + Input33) <= 40,Name),Name))