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

# set analysis multiple conditions

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'}

• ###### Re: set analysis multiple conditions

May be this

Count(DISTINCT {<[Participant Purpose]  = {'customer'}, [Conversation Direction] = {'inbound'}, [Formatted CLI] = {"=Sum([Aggr nOffered]) > 1"}>} [Formatted CLI])

• ###### Re: set analysis multiple conditions

Just have an idea that make it a little easier by creating a new table with 2 columns  are:

1. [Formatted CLI]

2. Flag_Aggr_nOffered = if (sum Aggr nOffered field> 1, 1, 0)

(you can do it in data load)

Then, the set analysis in 3rd will be simple:

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

Hope it help.