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!