Count records based on count of another field

[juleshartley]

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

   ,
)
)

[juleshartley · Accepted solution]

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!