1 Reply Latest reply: Jul 3, 2012 3:28 PM by mayilvahanan ramasamy RSS

    Set analysis problem

    NEIL ASHWORTH

      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