Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Person | Visit |
---|---|
Emily | 1/1/16 |
Emily | 2/1/16 |
Sal | 1/15/16 |
Sue | 2/15/16 |
Sue | 2/16/16 |
I want to be able to count the number of People if the visit count per person is greater than 1. So in the above table, my answer would be 2. I would count Emily and Sue, but not Sal.
Try as expression e.g. in a text box
=Count({<Person = {"=Count(Visit)>1"}>} DISTINCT Person)
Try as expression e.g. in a text box
=Count({<Person = {"=Count(Visit)>1"}>} DISTINCT Person)
Thank you, that worked perfectly!