I have a requirement to bring back the following:
- Distinct count of client records who have had a
- Visit that was part of more than one distinct activity
- Within a preiod of time
I tried the follwing, which seemed to bring something back but when I tried to add set analysis to display data year to date, the date field was ignored (I guess due to the aggr function)...
Any help gratefully received!