Skip to main content

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

 

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 ? 

 


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 

pBY:’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 ? 


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 :) 


Reply