Counting the number of times an employee's ID appears in another field

[alexisjensen]

Hi All,

I am working with a set of employee data and I need to be able to count how many direct reports each employee has.  I am pretty sure this will work by having a new column with a count of the number of times that ID number appears in the manager ID field.  eg: in the example data, for employee 520529, the return would be 12, because 520529 appears 12 times in the manager ID field.

I appreciate your help.

Regards,

Alexis Jensen

[ramatp30 · Accepted solution]

HI @alexisjensen

Is the attached workflow are you looking for?

Let me know if your looking for something else.

Thanks,

Ramana

[Inactive User]

Correct - Group by Manager field and then count. Can be done with 1 summarise tool.

[alexisjensen]

Thanks.  Works perfectly

Alexis