
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'}
please...
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Count(DISTINCT {<[Participant Purpose] = {'customer'}, [Conversation Direction] = {'inbound'}, [Formatted CLI] = {"=Sum([Aggr nOffered]) > 1"}>} [Formatted CLI])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Count(DISTINCT {<[Participant Purpose] = {'customer'}, [Conversation Direction] = {'inbound'}, [Formatted CLI] = {"=Sum([Aggr nOffered]) > 1"}>} [Formatted CLI])


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
