Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Hello,
Don't aggr in your set analysis, try this.
Count (Distinct {<[tAnsweres]=<{30}, [nAnswered] ={1}>} [ID: Conversation])
Regards
Acually the inequality should look like this:
=Count ({<tAnsweres={"<=30"}, nAnswered ={1}>} DISTINCT [ID: Conversation])