Set Analyis Combination

Anonymous — Fri, 23 Feb 2018 13:32:59 GMT

Hi,

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

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

Re: Set Analyis Combination

sunny_talwar — Fri, 23 Feb 2018 17:32:20 GMT

May be this

=Count(DISTINCT {$<StatChoice={'Email'}, Response = {'Yes'}>}Case)