ORC Candidate Diversity - Summary

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.