Alder Works asks you for a reproducible people report. Use the fictional extracts in this workspace. Keep the query from each step as the starting point for the next measure. Deliver the final requested result with the stated dates and eligible population.
Time to hire starts at a candidate event, while time to fill starts when the requisition opens. Employers choose different events, so the task defines both clocks. Here, time to hire runs from application to acceptance and time to fill runs from opening to acceptance, measured in calendar days. An unaccepted offer has no completed duration. Open requisitions need an aging measure at a fixed report date instead. Keep canceled requisitions separate from open work. A funnel yield also needs a denominator: offer acceptance is accepted offers divided by offers made, not applicants. Dates that run backward are data problems, not fast recruiting.
Distinguish application-to-acceptance time from requisition-to-acceptance time.
Completed candidate intervals use the application and acceptance events, not the employee start date.