Skip to main content

I am trying to select N number of months back fin a given metric based on an in Input Metric.

 

The Target Metric is dimension by Type in the rows and Month in the Column. The Input metric is dimensioned by Type and I have assigned a differing number of months to each type. The Calculation Metric in which I am placing the Formula should offset and select the value N Number of Months back based on the Input Metrics Months.

Here is an example formula:

Formula Metric:

‘TargetMetric’iSELECT: Month - InputMetric] but this throws an error about the month dimension.

How can I select a certain value from the target metric N number of months back based on an Input Metric?

Hi ​@LAS , 

Well, I would suggest you to ulilize PREVIOUS function with offset if it works for you.
Here’s the link for official documentation: 

 

Hi ​@LAS ,

The only thing you need to ensure is that the data type of the InputMetric is integer,.

 

Reply


Ask your question here!

Terms & ConditionsCookie settings