Skip to main content

​​​​​​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') Nby: -> 'EE_Card_Employee Manager'] &remove count: 'Employee']

​@ljanowski Here is another way you can do:

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

Reply


Ask your question here!

Terms & ConditionsCookie settings