Skip to main content

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! 

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

 

Hey Yaeji,

Did you manage to get forward with this? :)

yep!! 

Reply


Ask your question here!

Terms & ConditionsCookie settings