Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm struggling with a bit of set analysis. From the sample data below I'm trying to do a count of calls into response groups where they are missed. So id 1 went to 3 different users but was answered by one person so my expression would return 0. Id 2 went to 4 different users and was not answered by anyone and therefore would return 1.
ID call_response
1 Answered
1 Missed
1 Missed
2 Missed
2 Missed
2 Missed
2 Missed
Help please!
Thanks
Neil
Hi,
Try this,
=If(Aggr(Count({<call_response = {'Answered'}>}call_response),ID) > 0 ,0 ,1)Hope it helps