Count by hired and terminate dates and employee type

Question

Hello,

What is best way to setup the metric formula to summarize the # of headcount by following three?

by Division (using Division property)
by monthly (using Effective date property. This is basically monthly HC Data exported date.)
by Worker type. (using Worker Type property)

Thanks in advance!

Gawain · Accepted Answer

Hello Yaejis,You can try with this formula (to beadjusted to your block names):Load_transaction.’Employee ID’ [BY COUNT : Load_transaction.Division, Load_transaction.Month, Load_transaction.’Worker Type’]The Metric data type should be “Number” or “Integer” and the dimensions: Month, Division, Worker Type.To build this formula you can leverage the “Pigment Wizard” accessible through the Playground!Hope this helps