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 calculate tenure in job

edited Feb 11, 2019 8:43PM in Reporting and Analytics for HCM 6 comments

Summary

How to calculate tenure in job using OTBI

Content

Gurus—

I need to calculate the time in job per employee, for the current job (not previous jobs).  I searched the forum and there's lots of good advice about calculating time in organisation or service tenure.  I've been looking at Worker Assignment Event Real Time but I need a bit of help.  Can you recommend which fields to pull and how filter for the current job only?
I've pulled Effective Start Date and Effective End Date so I can see the job 'stack' and I just need to get the row for the current job, per employee.  I tried MIN(Effective Start Date) and MAX (Effective End Date) and that gives me one row per job per employee, but I need to get just the current job per employee.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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