Set Analyis Combination

[Anonymous]

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

[sunny_talwar]

May be this

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