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

Help with AVG function

Received Response
edited Dec 13, 2022 7:10AM in Taleo Enterprise 4 comments


I'm having some issues figuring out the AVG function. I'm getting data that doesn't make sense.

So, the TA manager wants to know the avg amount of days between certain events on a filled requisition. Such has avg days between approval and posting, and average days between posting date and the candidate that was hired applied for the job, etc. So I built formulas for each of the "windows" using the avg function.

For example, here is my formula for the days between when the job was posted and the hired candidate finished their submission:

Avg(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", "Submission Dates"."Submission Completed Date"))

Howdy, Stranger!

Log In

To view full details, sign in.


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