Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Jsobrinho77
Creator
Creator

moving average for all dates

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

Labels (4)
0 Replies