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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Custom Average Time to Fill minus weekends

edited Dec 13, 2022 7:06AM in Taleo Enterprise 3 comments

Summary

Need to remove weekends from custom CSW driven TTF

Content

Hi All,

Following some great help from you here I now have a great custom TTF report using CSW stages however I am now stuck as the business are asking for the weekends to be removed from the calculations and I am stumped and havent been able to find anything online due to the custom code I am already using.

 

Can anyone help to change my current code for weekends to be discounted from the calculations?

Avg(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Fully Approved Date",(CASE WHEN "Submission CSW Status - Historical"."Historical Step Name"='New Hire Checks' OR "Submission CSW Status - Historical"."Historical Step Name"='Post Offer Checks' THEN "Submission CSW Status - Historical"."Historical Status Event Date" END))-"Requisition Aging"."Time On Hold Since First Approval")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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