I have data for employee's as such:
Recruiter........Employee ID............Employee Status
Steven..........643983489..............ACTIVE
Hailey...........643983578..............LEAVE OF ABSENCE
Steven..........643983834..............ACTIVE
Steven..........643983001..............TERMINATED
Steven..........643983283..............ACTIVE
Hailey...........643983542..............ACTIVE
Steven..........643983111..............LEAVE OF ABSENCE
Hailey...........643983782..............ACTIVE
I am trying to build a query that calculates the percentage of total that is Active or Leave of Absence by each recruiter. Is there a way to do this, or a workaround using multiple queries? I appreciate any help!