Can't add an integer/double to a vector

[kiimot]

Good morning! I am trying to create a vector in which to store a value of the last 25 days for each date

When I try to generate the vector, it does it correctly, but when I show the measure in the dashboard I get an error.

Am I doing something wrong? Is it possible to do it in a simpler way?

That is, I have a field that calls DURATION.MEAN for each day. But I want a measure that takes me the average value of the last 25 days of each date, and if that date does not have -25, I leave it blank...

Steps to reproduce

The vector creates it correctly, but when I try to display it on the dashboard, I get an error

Actual Result

This is the error... Maybe I have to do it in another way.

Expected Result

Have a new column called 'AVERAGE DURATION LAST 25 DAYS' in which print the corresponding values

Environment

• atoti: 0.7.2
• Python: 3.10.10
• Operating System: Windows 10 Enterprise

Logs (if relevant)

[tibdex]

Hi,

You're speaking of a vector/array but I don't see one in the screenshots you shared. Could you share the code of a minimal reproducible example so that we can help you?

[kiimot]

Hi!

The capture of the vector/array is this.

What I'm trying to do is... Imagine I have two columns, one with the date and the other with the duration of that date.

Well, the objective is to add a measure so that the value shown on each date is the average duration of the last 25 days.

For example, today February 20, I took an average duration from January 28 (-25 days).

And so with all available dates.

[kiimot]

Hi!!

Have you been able to verify the error?

[tibdex]

m["DURACION.MEAN"] doesn't seem to be an array so you can't index it (with []). Maybe you need a CumulativeScope with a time period window?