Percentage of hires that were referral
Our TA department wants to know what percentage of our external hires have referral as their source.
I've tried this as a formula but I'm only getting '1' as the answer. Any one know what changes I need to make?
COUNT(DISTINCT case when "Submission Source"."Submission Source Type" = 'Referral' then 1 end)/COUNT(DISTINCT case when "Submission CSW Status - Current"."Current Status Name" = 'External Hire' then 1 end)