Hello,
I created the below metric but the result is not what i expect.
I would like to have only the “new deals. TTR first date” for the “Budget 2024” version.
Currently my metric is displaying the “new deals” dimension list of all my version (Reforecast july 2023 and Budget 2024). Version is a property of New deals.
You will find below the new deals dimension list.
thanks for your help
Best answer by Nathan
View original
+11
Hi Cedric,
My guess: your metric Cohort Maturity in Years has the Version dimension, so Pigment keeps it.
Use something else or do a [select:Versions.”Name”] on it in your formula
Cohort maturity in years is a dimension so it has no version dimension.
If i use a “select” the formula won’t be dynamic anymore.
Is there an other way of doing it ?
+11
So version is a dimension of your target metric ?
You could just remove it, but if you have it as a property of New deals then you should do a
[BY:’New Deals’.Version]
Yes version is a dimension of my target metric.
I have the below error when using a by
Any update on my previous comment ?
+11
as with your other post I think you need the famous → in your by, otherwise it removes the deal dimension and thus can’t do it
Thanks, it works perfectly :)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
