1 Reply Latest reply: Mar 26, 2013 10:49 AM by Hartley Julian RSS

    Count records based on count of another field

    Hartley Julian

      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

         ,
      )
      )