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
Gather %'s in OBI for Diversity Numbers — 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

Gather %'s in OBI for Diversity Numbers

Accepted answer
67
Views
7
Comments
edited Mar 24, 2017 7:44PM in Reporting and Analytics Taleo Enterprise 7 comments

Summary

Looking for help on SQL which can calculate %'s of Diversity data

Content

Good day all and Happy Friday.

I have a diversity report nearly completed.  I have various count objects which tally's the appropriate diversity data.  However, I need to create %'s of X.

My SQL is average at best.  I've tried modifying the formula and in all cases, I didn't receive any errors, but when viewing the results of the analysis, it wasn't calculating correctly.

Here are a few examples of what I'm looking for: 

Out of the total # of hires, what % of those are female?

Out of the total # of hires, what % of interviews were were diverse hires?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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