Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
% Of Submissions Passed through Steps in CSW — 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

% Of Submissions Passed through Steps in CSW

Received Response
206
Views
11
Comments
edited Jul 2, 2015 1:42PM in Reporting and Analytics Taleo Enterprise 11 comments

Summary

This is an example report that shows the percentage of submissions that have passed through various CSW Steps.

Content

The attached report highlights the use of the following formula to show how many submissions are progressing to selected steps.

ceiling (count(distinct case when "Submission CSW Status - Historical"."Historical Step Name" = 'Step' then "Submission General Info"."Submission Identifier" end) / "Candidate Counts"."# Submissions" * 100 )

The ceiling function is used to round decimals up to the next integer, for instance 9.1 will round to 10.  To customize this report for use in your zone you will change the step in the formula - 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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