Help with AVG function
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"))