Set Analysis?

[Anonymous]

Hi

I am trying to create a chart that shows 3 figures:

The number of donors that have given to an appeal

The number of donors that have given to an appeal and only to this appeal

The number of donors that have given to an appeal and another appeal.

I have attached a simplified example,

with this data:

Load * inline
[
GiftID, Donor, Appeal
0001, 1, Appeal_A, 
0002, 1, Appeal_B, 
0003, 1, Appeal_A, 
0004, 2, Appeal_A,
0007, 3, Appeal_A, 
0008, 3, Appeal_A,
0009, 3, Appeal_A, 
0010, 3, Appeal_B, 
0011, 3, Appeal_B, 
0012, 4, Appeal_A,
0013, 4, Appeal_A,
0014, 5, Appeal_B, 
0015, 5, Appeal_B, 
0016, 5, Appeal_B,
0017, 6, Appeal_C
];

I would like the chart to show           

                          Given to this Appeal           Given Only to this Appeal            Given to this Appeal and other Appeal

AppealA                   4                      2                                 2

AppealB                   3                      1                                 2

AppealC                   1                      1                                 0

Any help much appreciated.

David

[sunny_talwar · Accepted solution]

Try these expressions:

Count(DISTINCT Donor)

Count(DISTINCT {<Donor = {"=Count(DISTINCT Appeal) = 1"}>}Donor)

Count(DISTINCT {<Donor = {"=Count(DISTINCT Appeal) > 1"}>}Donor)

[Anonymous]

Thank you Sunny T

That gives me to right answer, but I should have said that the "The number of donors that have given to an appeal and another appeal". needs to include all appeals not just the selected appeals.

So if I select AppealA the chart would still show 4  2  2 for that appeal. Rather than 4 4 0

[sunny_talwar]

‌Add set analysis to your search string to ignore selection in Appeal.

=Count(DISTINCT {<Donor = {"=Count(DISTINCT {<Appeal>}Appeal) = 1"}>}Donor)

=Count(DISTINCT {<Donor = {"=Count(DISTINCT {<Appeal>}Appeal) > 1"}>}Donor)

UPDATE: Sample attached for reference

[Anonymous]

Thanks again Sunny T

That gives me exactly what I need.

I really appreciate your time on this.

Best wishes

David

[sunny_talwar]

No problem David, I am glad I was able to help