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

Offer Acceptance Rate - Counting the LAST offer extended to a candidate

Accepted answer
36
Views
3
Comments
edited Dec 13, 2022 7:08AM in Taleo Enterprise 3 comments

Summary

Need help with formulas/filters

Content

Hi Experts!

I was trying to adjust the following formula to look at the "LAST offer" extended to a candidate instead of counting all extending offers for offer acceptance rate. Is there a way to include the LATEST OFFER APPROVAL DATE with the formula below - SQL Formula? Thank you so much. 

SQL Formula

cast(count (case when "Submission Job Offer"."Status" in ('Accepted') then "Submission General Info"."Submission Identifier" end)/count(case when "Submission Job Offer"."Status" in ('Refused','Accepted','Reneged') then "Submission General Info"."Submission Identifier" end) as double) *100 

SQL Formula in Testing - Didn't get the correct counts by month, but it shows accurate count when the analysis is down to one month

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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