12 Replies Latest reply: Dec 27, 2017 11:22 PM by Isabel Encinas RSS

    count if multiple dimension

    Isabel Encinas

      Hi Everyone,

       

      Please help.

       

      I'm trying to count those ID Conversations that were answered within 30seconds.

       

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

          sample.JPG

       

      I just do not know how to insert the [nAnswered] condition on the below.

      Count({<[Aggr tAnswered]={'<=30'}>}Distinct [ID: Conversation])