Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Help with AVG function
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"))
Tagged:
0