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!
Best answer by francoisView original
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!
Yes that’s exactly what I was looking for! I was trying some complex formulas when it was so simple as that!