1 Reply Latest reply: Feb 23, 2018 12:32 PM by Sunny Talwar RSS

    Set Analyis Combination

    Paul Sparrow

      Hi,

       

      I am trying to summarise data by a field called StatChoice.

       

      StatChoice
      Email
      Phone
      Yes
      No

       

      This field contains varied answers which I need to combine, for example count the number of Cases which have an 'Email' flag


      The expression works when in a textbox when I use:


      =(Count(Distinct{$<StatChoice={'Email'}>}Case)


      However, I want to summarise this further by counting the number of cases with an 'Email' flag and a response of 'Yes'


      Any suggestions on how this can be achieved?


      Thanks,

      Paul