Forum Discussion
Resolver IEMPLOYEE TURNOVER
Hola!
Necesito calcular el Turnover de los empleados de mi empresa en el mes en curso y poder tener tambien un histórico por meses y años.
He leido muchos posts por aqui pero no lo consigo.
Tengo la info de los empleados (nombre - fecha inicio - fecha fin (si está en blanco está activo) y tengo un calendario el cual, no se porque solo me deja relacionar o con la fecha de inicio o con la de fin, no puedo hacer las dos relaciones.
Necesito calcular, para publicar una tarjeta, el turnover employee a dia de hoy=Empleados que se han ido en los últimos 12 meses / Promedio de números de empleados de los últimos 12 meses
Y si se pudiera tener un histórico para poder publicar una gráfica tipo
4 Replies
Hi ElenaCarciLopez ,
In my experience, you probably don't need to bind a relationship to a start date or an end date. Just go through a date table and determine if it's between the two dates based on the selected time. You might use selectvalue.
Please feel free to correct me and provide more information if I have misunderstood you!
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
ElenaCarciLopezHi, OK I don´t need a relation between dates, but I don't succed in obtaining the employee turnover formula.
I need a card with
Turnover Global 12 months rolling (from the actual month counting the 12 past months)
Nº employees terminated during the last 12 months / Average demployees of the last 12 months
The average employees of the last 12 months should be calculated = active employees each month / 12 months or starting employees + ending employees /2, but how I put in the formula is for the last 12 months?
Hi ElenaCarciLopez ,
Please provide sample data in a table format along with your expected results.
Best regards,
Community Support Team_ Scott Chang
