RangeCorrel

[olgaavalos]

Hello,

Please, I need the following formula to use it in a line chart whose dimension is the dated_liquidity. However, it works only in a KPI and by selecting one date at a time.

I'm using Rangecorrel but it doesn't work.

The formula:

Correl({<Fecha_Liquidez={">$(=Max({<Num_Fecha={$(=Max(Num_Fecha)-60)},Fecha_Liquidez=>}Fecha_Liquidez))<=$(=Max(Fecha_Liquidez))"}>}Variaciones, VariacionesII)

And I am trying to chage for this one, but it is not working:

RangeCorrel(above(Variaciones,60), above(VariacionesII,60))

[Benoit_C · Accepted solution]

Hello @olgaavalos,

It seems like you are trying to calculate the correlation between two variables Variaciones and VariacionesII over a rolling period of 60 days. The original formula you provided seems to be using the Correl function with set analysis to filter the data based on the date range.

To modify this formula to work in a line chart with the dimension dated_liquidity, you can try using the Above function to get the rolling period and then apply the Correl function. Here's the modified formula you can try:

Correl(Above(Variaciones,60), Above(VariacionesII,60))

Regards,
Benoit