set analysis multiple conditions

[Anonymous]

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...

[sunny_talwar · Accepted solution]

May be this

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

[thi_pham]

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.

[Wallibee]

Hi @sunny_talwar 

I have trying to use multiply conditions in my set analysis but it seems not to work. 

Sum({< [Factuur Datum.Calendar.Year]={$(=year(date(max([Factuur Datum.Calendar.Year]))),[Artikelhoofdgroep Statistiek ID] ={4},[Dim Artikelsubgroep Statistiek.Omschrijving NL]={'AC','AB'}>}[Totaal Netto Euro])

Please I would need some help on this.