Skip to main content
Question

Count # of direct reports each month

  • July 10, 2025
  • 1 reply
  • 27 views

Forum|alt.badge.img+7

​​​​​​I have a metric called 'EE_Card_Employee Manager' with the following:

Dimensions (2): ‘Employee’ & ‘Month’

Data Type: Dimension ‘Employee’

Currently the metric shows each employee’s manager each month. I would like to create a new metric that counts an employee’s # of direct reports by month. 

I am using the following formula which is not returning the correct result, can someone please advise?

COUNTOF('EE_Card_Employee Manager') [by: -> 'EE_Card_Employee Manager'] [remove count: 'Employee']

1 reply

Min Li
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • July 10, 2025

@ljanowski Here is another way you can do:

EE_Load_HRIS.Employee[BY COUNTUNIQUE:EE_Load_HRIS.'Employee Manager',EE_Load_HRIS.'HRIS Load Month']