The total count of employees that have moved internally from one internal job to another internal job.

Calculation: CNT([HRIS.Candidate.Candidate_ID] IF([ATS.Candidate.Source] = Internal))

Stage Aging

The total number of calendar days a candidate remains in one of the AEIOU stages, where A = applicant, E = evaluated, I = Interviewee, O = Offeree, U = unwanted

Calculation: DATEDIFF[Stage – Previous Stage]

Time to Submit

The number of calendar days that have elapsed from the application date until the the candidate is submitted to the hiring manager for further review

Calculation: DATEDIFF([ATS.Candidate.Submission_Date]-[ATS.Candidate.Application_Date])

Job Abandonment

The percentage of requisitions that have been successfully opened but whose efforts, for one reason or another, have been permanently stopped and no hire is made


CNT([IF Posted.Date <> EMPTY AND DATEDIFF([Cancelled.Date] – [Posted.Date ]) > 30])


A candidate who has been interviewed by a hiring manager

OPTION 1: SUM([ATS.Candidate.Interview_Binary])
OPTION 2: CNT([ATS.Candidate.Interview_Binary]=1)