Solved

Count by hired and terminate dates and employee type


Userlevel 3
Badge +6
  • Newly Minted Pigmenteer
  • 21 replies

Hello, 

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

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

 

 

Thanks in advance! 

icon

Best answer by Gawain 11 May 2023, 12:03

View original

3 replies

Userlevel 4
Badge +5

Hello Yaejis,

 

You can try with this formula (to be adjusted 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

 

Userlevel 5
Badge +8

Hey Yaeji,

Did you manage to get forward with this? :)

Userlevel 3
Badge +6

yep!! 

Reply