2 Replies Latest reply: Jan 29, 2018 2:05 AM by Jonathan Dienst RSS

    countif sum is <

    Isabel Encinas

      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])