Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
No the set is wrong - in fact it is working as OR I want this to be done as AND
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)