Exponentially weighted moving average

[R2Tom]

I didn’t tried it yet, but could be possible now:

@david

The formula is evaluated once for each day in the date range. You can assign values to variables and these carry over from one day to the next (0 for the first day). You can create multi line expressions where the value of the expression is the value from the last line.

Here is the exponentially weighted moving average for fitness (CTL):

f = exp(-1 / 42)
v = v * f + (fitness_load ?? 0) * (1 - f)

Note the use of the ?? operator to convert null or undefined fitness_load (no training on that day) into zero