Hello,
I am trying to create a metric with the number of sales by seniority in month.
I have a metric with the number of new hires and a tenure cohort dimension made up of 0, 1 and 2+ months. For example if I have 2 new hires in September 2023, I want to see 2 in the “0” line in Sept-23, then 2 in the “1” line in Oct-23 and 2 in the “2+” line in Nov-23.
I hope this is clear enough!
Thanks!
Elodie
Best answer by Benoit
View original
+12
Hi Elodie,
I made a simpler reproduction, hoping the outcome is what you were trying to achieve:
here is my source metric of new hires per month
and here is the seniority by tenure month:
The formula I used is:
if('Tenure cohort'."0", 'Sales per month',
if('Tenure cohort'."1", 'Sales per month'[select: Month -1],
cumulate('Sales per month'[select:Month-2],Month) ) )
Hope it helps.
Best,
Hi Benoît,
Thank you for your help! I have adapted your formula to obtain the result I was looking for!
Have a nice day,
Elodie
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
