Offer Acceptance Rate - Counting the LAST offer extended to a candidate
SummaryNeed help with formulas/filters
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.
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