"I would like to consider the CEO as the head of the department, and all other job titles would be positioned below the CEO. This will enable me to calculate the retention rate of employees under each specific CEO and their corresponding departments."
The provided image illustrates various departments and their corresponding job titles. The termination status is denoted by '0' for not terminated and '1' for terminated employees. My goal is to visually analyze the number of terminated employees under the CEO, who is considered the head of the organization. I am interested in creating a visualization that demonstrates the count of terminated employees under each CEO.
3 answers
Refer the below attached workbook.
