Turnover cohort

Question

Hello,I am trying to create a metric that shows the month tenure by employee in a cohort, with the cohorts in rows and the month cohort dimension in columns (i.e. M+1, M+2, M+3, etc.). For example, an employee who arrived in May 22 is part of the May 22 cohort and if he leaves in September 22 it would put a 1 in the column "M+4" for the row "May 22".I have an “Employee” dimension with a property for the cohort (for example May 22) and a property for the number of months of employment (for example M+4).Could you please help me to build in the best way the described metric?I hope my request is clear enough!Thanks! 😊

francois · Accepted Answer

Hi Élodie,I think you’re looking for the COUNT aggregator using BY. Here are some details on the topic.You could try something like Employee[BY COUNT: Employee.'Cohort', Employee.'Month Cohort'] if you have both Cohort and Month Cohort as properties of your Employee dimension.The target result should be an integer metric, with dimensions Cohort and Month Cohort.Let me know if that works for you!

Elodie · Answer

Hi François,Yes that’s exactly what I was looking for! I was trying some complex formulas when it was so simple as that!Thank you!!

Turnover cohort

2 replies

Ask your question here!

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded