Hello,
I am trying to calculate the number of employees who left by hire date cohort and number of months that they stayed in the society. Here is the formula I have (but doesn’t work because it is too complicated I think):
Employee [BY COUNT: Employee.'Cohort Month', Employee.'Month tenure cohort', Employee.Country, Employee.'First Job Position'.'Team Graph HR']
The Cohort month corresponds to the month of arrival.
The Month tenure cohort corresponds to the number of months the employee stayed in the society.
I want this metric by team department (Team Graph HR) of their first job position (because some employees can evolve from one job to another in the company).
Could you please help me finding the best formula here?
Thanks!
Elodie
Best answer by Elodie
View original