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

Formula for # of candidates in Inteview step

Accepted answer
49
Views
1
Comments
edited May 16, 2017 3:44PM in Reporting and Analytics Taleo Enterprise 1 comment

Summary

We currently have a formula to count the number of candidates in the interview step (not including those rejected) but we have added a new status and need to update the formula

Content

Our current formula for the "# of Candidates in Interviews" is EVALUATE_AGGR('COUNT(DISTINCT CASE WHEN %1 In (''Interviews'') AND %2 In(''Schedule face to face Interview'',''Face to Face Interview Scheduled'',''Under consideration after interview'',''Schedule follow-up Interview'',''Follow-up Interview Scheduled'',''Progress to Offer Stage'')  THEN %3 END)' AS NUMERIC,"Submission CSW Status - Current"."Current Step Name","Submission CSW Status - Current"."Current Status Name","Submission Identifier")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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