Gather %'s in OBI for Diversity Numbers
SummaryLooking for help on SQL which can calculate %'s of Diversity data
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?