I am trying to get employees attrition rate.
I have one table with list of employees , start date and termination date , department and country ,
I want to get attrition rate per month, per country , per department. Screenshot of data
output should have date (per month), department, country, leavers , joiners , employees
where Attrition % = (No. of employees left the organisation at specific month) / number of employees that month X 100
Thank you !