Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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!
Thanks
J
count
(distinct
{$
<
cRecordType={"Client"}
>
}
if
(
aggr(count(DISTINCT
visActivity),#cID )>1,
#cID
,
)
)
Think I've answered my own question - when adding the set analysis for dates I need to put it within the aggr function as well as outside...
Thanks all!
Think I've answered my own question - when adding the set analysis for dates I need to put it within the aggr function as well as outside...
Thanks all!