Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Help with AVG function — Cloud Customer Connect
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
15
Views
4
Comments
edited Mar 25, 2020 2:30PM in Reporting and Analytics Taleo Enterprise 4 comments

Content

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.

Register

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