Skip to content
Gallery
Template PreviousRow() in Coda
previousRow()
Rolling Total
DB Wood Sales
DB Wood
Moving average
DB Brussels - Paris
Share
Explore

icon picker
Moving average

filter on the dates, slice it and average the outcome
My blog explaining the logic:
⁠
Moving average in Coda
Comparing dates and using filters
huizer.medium.com
⁠
⁠

⁠
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:


⁠
Moving Average (6 Period)
hi @Jean-Claude_Siliato , I could not access the doc, but I copied the table and this is what I got this is the code part, maybe the screenshots in my blog help you to see the logic. thisTable.Sort(True(),sortBy: thisTable.Date).Filter(Date <= thisRow.Date).[Per Unit].Slice(-6).Average() Cheers, Christiaan
community.coda.io
⁠
⁠
Test Table
1
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 (
CtrlP
) instead.