Skip to content
Moving average
filter on the dates, slice it and average the outcome
My blog explaining the logic:
Name
Date
Number
moving average
1/1/2023 → 1 values
1/1/2023
34
34
1/2/2023 → 1 values
1/2/2023
47
40.5
1/3/2023 → 1 values
1/3/2023
56
45.67
1/4/2023 → 1 values
1/4/2023
22
39.75
1/5/2023 → 1 values
1/5/2023
65
44.8
1/6/2023 → 1 values
1/6/2023
13
39.5
1/7/2023 → 1 values
1/7/2023
38
40.17
1/8/2023 → 1 values
1/8/2023
27
36.83
1/9/2023 → 1 values
1/9/2023
50
35.83
1/10/2023 → 1 values
1/10/2023
62
42.5
1/11/2023 → 1 values
1/11/2023
19
34.83
1/12/2023 → 1 values
1/12/2023
40
39.33
1/13/2023 → 1 values
1/13/2023
11
34.83
1/14/2023 → 1 values
1/14/2023
53
39.17
1/15/2023 → 1 values
1/15/2023
29
35.67
1/16/2023 → 1 values
1/16/2023
70
37
1/17/2023 → 1 values
1/17/2023
15
36.33
1/18/2023 → 1 values
1/18/2023
44
37
1/19/2023 → 1 values
1/19/2023
31
40.33
1/20/2023 → 1 values
1/20/2023
58
41.17
1/21/2023 → 1 values
1/21/2023
23
40.17
1/22/2023 → 1 values
1/22/2023
66
39.5
1/23/2023 → 1 values
1/23/2023
12
39
1/24/2023 → 1 values
1/24/2023
49
39.83
1/25/2023 → 1 values
1/25/2023
37
40.83
There are no rows in this table
Request in the community:
Test Table
Date
Per Unit
Average
ROW ID
31/01/2023
1
1
1
28/02/2023
1.2
1.1
2
31/03/2023
1.3
1.17
3
30/04/2023
1.25
1.19
4
31/05/2023
1.2
1.19
5
30/06/2023
1.1
1.18
6
31/07/2023
1.3
1.23
7
31/08/2023
1.4
1.26
8
30/09/2023
1.65
1.32
9
31/10/2023
1.6
1.38
10
30/11/2023
1.5
1.43
11
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.