AND in Set Analysis

[tahirkhalil]

HI All,

How can I implement AND within SET.

I have an example - one ticket contain multiple activities and have responses against each.

For me a valid ticket is only one which have Activity A3 and A4 both with response 1.

I know if I use =count(DISTINCT {<Activity={"A3","A4"}, Response={1}>} Ticket) - it is working as OR. I want to use condition:

(Activity = A3 AND Activity = A4) AND Response=1

How to achieve that through set analysis? See attached document.

Regards,

Tahir

[Thiago_Justen_]

Your set is ok. Try it without the distinct...I guess you have the same ticket for both activities and response. Then you got only 1 as result because of the distinct.

[tresesco · Accepted solution]

Try like:

=count(DISTINCT {<Ticket=p({<Activity={'A3'}, Response={1}>})
*
p({<Activity={'A4'}, Response={1}>})>} Ticket)

[tahirkhalil]

No the set is wrong - in fact it is working as OR I want this to be done as AND

[robert99]

Hi

I haven't a clue what you are trying to achieve to be honest

But would this work

count(DISTINCT {<Activity={"A3","A4"}>} Ticket)

+

count(DISTINCT {<Response={1}>} Ticket)