Hello,
What is best way to setup the metric formula to summarize the # of headcount by following three?
Thanks in advance!
Best answer by Gawain
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
+9Hello 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
