hi guys,
I would replicate the moving average for the max 3 dates, to all dates, like a reference line, so my chart will have a line with the same value as the moving average for max 3 dates.
RangeAvg(Above(total
Sum({<Date={"<=2024-01-10"}>} Value),0,3))
the expected result is a line with value 44.33 ( 2024-01-10 = 79, 2024-01-09 = 36, 2024-01-08 = 18 ) for all dates