ORC Candidate Diversity - Summary — 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

ORC Candidate Diversity - Summary

edited Apr 6, 2021 1:32PM in Reporting and Analytics for HCM 2 comments

Summary

Getting to one row per job requisition?

Content

I've created an analysis that uses the delivered counts of applications, veterans, gender, and disability status that are self-reported by candidates that apply. However ethnicity is another matter - counts of applicant ethnic group are not included in the Job Application - Legislative Info folder for some reason.

I can create a column to count each ethnic group response (or lack thereof), and I'm pretty sure that I can add the non-white positive responses together to generate a single column for total ethnically/racially diverse candidates per my reporting requirements. 

However, OTBI seems to require that I include the Ethnic Group (name) column in order to display these counts, meaning I end up with multiple rows of results per requisition. I suppose it's helpful that the delivered "Count" fields from the Job Application - Legislative Info records break out by the ethnic groups present for the requisition, but I really only want one row with the total counts for THAT requisition.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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