2 Replies Latest reply: Jul 9, 2018 10:27 PM by Thi Pham RSS

    set analysis multiple conditions

    Isabel Encinas

      i have two expressions that i want to combine.

       

      1. (count(aggr(if(Sum([Aggr nOffered])>1,num(Sum([Aggr nOffered]),vFormatSeconds2), null()) ,[Formatted CLI]) ))

      counting the Formatted CLI with sum Aggr nOffered field> 1

       

      2. count(distinct{<[Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}>} [Formatted CLI])

      counting the Formatted CLI with [Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}

       

      3. expected set analysis should be:

      counting the Formatted CLI with Sum Aggr nOffered field> 1 ,[Participant Purpose]  ={'customer'},[Conversation Direction]= {'inbound'}

       

      please...