AnsweredAssumed Answered

Unique Count of a Summary List

Question asked by on Feb 24, 2018
Latest reply on Feb 24, 2018 by

Hi everyone:


I'm currently trying to calculate the number of employees who worked on a particular job. I was able to achieve the result I was looking for using the ExecuteSQL function. However, I'd like to achieve the same result without using the ExecuteSQL function.


I created a summary field (sum_test), which counts the number of WorkerIDs but the problem is that a worker may clock in and out of a job more than one time during the day or pay period.  I created a summary field (sum_ListWorkerID) listing the WorkerIDs. The duplicates are a result of clocking in and out. I also created a field to get the unique values , UniqueValues (  List ( sum_ListWorkerID ) which returns a list of all workers whether they worked on the job or not. So I get the following result:


Screen Shot 2018-02-24 at 9.02.58 AM.png

Ultimately, I'd like to achieve the result of 4, the unique values of the summary field, sum_ListWorkerID.


Any help on this would be greatly appreciated.