countif sum is <

[Anonymous]

I'm  counting those ID Conversations that were answered within 30seconds.

count id conversations if [tAnswered]<=30 and [nAnswered] =1

I've tried this expression, but there are 2 conversations that have incorrect results. (see attached)

Count( Distinct {<[Aggr tAnswered] ={"=sum([Aggr tAnswered])/1000<=30.00"},[Aggr nAnswered] ={1}>} [ID: Conversation])

[hhajjali]

Hello,

Don't aggr in your set analysis, try this.

Count (Distinct {<[tAnsweres]=<{30}, [nAnswered] ={1}>} [ID: Conversation])

Regards

[jonathandienst]

Acually the inequality should look like this:

=Count ({<tAnsweres={"<=30"}, nAnswered ={1}>} DISTINCT [ID: Conversation])