JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Template PreviousRow() in Coda
previousRow()
Rolling Total
DB Wood Sales
DB Wood
Moving average
DB Brussels - Paris
More
Share
Explore
Moving average
Moving average
filter on the dates, slice it and average the outcome
filter on the dates, slice it and average the outcome
My blog explaining the logic:
Loading
huizer.medium.com
Name
Date
Number
moving average
Name
Date
Number
moving average
1
2023-01-01 → 1 values
1/1/2023
34
34
2
2023-01-02 → 1 values
1/2/2023
47
40.5
3
2023-01-03 → 1 values
1/3/2023
56
45.67
4
2023-01-04 → 1 values
1/4/2023
22
39.75
5
2023-01-05 → 1 values
1/5/2023
65
44.8
6
2023-01-06 → 1 values
1/6/2023
13
39.5
7
2023-01-07 → 1 values
1/7/2023
38
40.17
8
2023-01-08 → 1 values
1/8/2023
27
36.83
9
2023-01-09 → 1 values
1/9/2023
50
35.83
10
2023-01-10 → 1 values
1/10/2023
62
42.5
11
2023-01-11 → 1 values
1/11/2023
19
34.83
12
2023-01-12 → 1 values
1/12/2023
40
39.33
13
2023-01-13 → 1 values
1/13/2023
11
34.83
14
2023-01-14 → 1 values
1/14/2023
53
39.17
15
2023-01-15 → 1 values
1/15/2023
29
35.67
16
2023-01-16 → 1 values
1/16/2023
70
37
17
2023-01-17 → 1 values
1/17/2023
15
36.33
18
2023-01-18 → 1 values
1/18/2023
44
37
19
2023-01-19 → 1 values
1/19/2023
31
40.33
20
2023-01-20 → 1 values
1/20/2023
58
41.17
21
2023-01-21 → 1 values
1/21/2023
23
40.17
22
2023-01-22 → 1 values
1/22/2023
66
39.5
23
2023-01-23 → 1 values
1/23/2023
12
39
24
2023-01-24 → 1 values
1/24/2023
49
39.83
25
2023-01-25 → 1 values
1/25/2023
37
40.83
There are no rows in this table
Request in the community:
Loading
community.coda.io
Test Table
Test Table
1
Date
Per Unit
Average
ROW ID
Date
Per Unit
Average
ROW ID
1
31/01/2023
1
1
1
2
28/02/2023
1.2
1.1
2
3
31/03/2023
1.3
1.17
3
4
30/04/2023
1.25
1.19
4
5
31/05/2023
1.2
1.19
5
6
30/06/2023
1.1
1.18
6
7
31/07/2023
1.3
1.23
7
8
31/08/2023
1.4
1.26
8
9
30/09/2023
1.65
1.32
9
10
31/10/2023
1.6
1.38
10
11
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.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.