AnsweredAssumed Answered

Count unique records in a found set

Question asked by sp-1370 on Aug 26, 2016
Latest reply on Aug 26, 2016 by coherentkris

Hi Everyone,

 

I'm not a programmer, but a fast learner.  I have a database of Courses watched by date; and I am trying to count the # of users that logged in to the system to watch a course within a date range.

 

Since a user could have watched 15 courses, I need to count the unique user records.  I have this working as a whole using the following method in the field calculation:

 

1 / GetSummary (TotalCount ; LocationField)

 

Although, I have discovered that I would need to write a script to produce a correct result for a found set.  This is my trouble (as stated before I'm not a programmer), however, I can find a few scripts online but am unclear which fields would be the list field (where the script gets the data) and the return result field (where the end value displays).

 

And any provide a script they've used and let me know for "fieldname" which field they have used (list field or result field).

 

I apologize for my laughable language to the programmers, and thank you in advance.

 

Thanks again,

Rachael

Outcomes