Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Formula for # of candidates in Inteview step — Cloud Customer Connect
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
edited Dec 13, 2022 7:06AM in Taleo Enterprise 1 comment


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


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.


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