Time to Fill, Distributed

The total count of calendar days it takes to fill a position, distributed into multiple time buckets. It is measured from the Recruiting Start Date to the Offer Accepted date.  We recommend using the following buckets:
0-15 Days

16-30 Days

31-45 Days

46-60 Days

61-75 Days

75+ Days

Calculation: COUNT([ATS.Requisition.Req_ID] IF (DATEDIFF([ATS.Candidate.Offer_Accepted_Date] – [ATS.Requisition.Recruiting_Start_Date] = {Bucket})))