Skip to main content

Hello,

I need help retrieving information for a metric of the monthly type. This metric consists of 3 dimensions (operation, cohort, month). I would like to retrieve in which cohort the operations are in December '23. And thus obtain a cohort type metric with the operation as its dimension.

For exemple for this operation, I like to retrive the M+106 cohort.

 

Thanks for your help.
:) 

 Hi @Antoine-2 ,

If you are looking to retrieve in which cohort the operations only when the monthly type is equal to December 23.
the formula would be: 

IF('Monthly type' = Month."Dec 23", Cohort)rREMOVE LASTNONBLANK: Month, Cohort]

where:

  • If(Monthly type = Month.”Dec 23”,cohort) would result in a cohort type metric retrieving the cohort value only when Monthly type metric equals Dec 23. this metric would have the same dimensions as Monthly type metric (Operation, Cohort, Month)
  • lREMOVE LASTNONBLANK: Month, Cohort] would remove the Month and Cohort dimensions and keep the last non blank value. Which will result in a Cohort typer metric with only Operation as a dimension.


 

Hope this helps,
Issam

Reply


Ask your question here!

Terms & ConditionsCookie settings