You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to add a count column for employees aligned to a job in OTBI.

Received Response


I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job in myHR. I need this to exclude Inactive employees and also count jobs which no employees are aligned too. When I used the below measure it done the count as I wanted but also removed around 2.5k jobs from my report where previously they were showing. Is there a better way to do the case? Thank you for your help!

I've added the full XML for detail. Thank you.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!