Skip to content
Gallery
Peter's Coda Problems
Rolling Averages Test
Rolling Averages Test
More
Share
Explore
Rolling Averages Test

PeterG01

I created a Name column and used a format to show all relevant information at once. The name column is set as display column.
Step01 We create a filter that brings together everything related to the client in the table
Step02 We sort on Date and we note there is no difference in this table. Still an important step.
Step03 we bring the WithName logic into play
step 04 we create the groupIndex (index per group of clients, sorted by date)
step 05, ad Spend per client
step 06 sliced ad spend
step 07, rolling total
PeterG01
1
Client
Date
Ad Spend
step01
step02
step03
step04
step05
step06
step07
Column 11
Name
1
Client B
11/1/2022
600
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
1
600700150450350
600
600
​
Client B - 11/1/2022 - 600
2
Client C
11/1/2022
650
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
1
650450200800350
650
650
​
Client C - 11/1/2022 - 650
3
Client A
11/1/2022
450
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
1
450900100500350
450
450
​
Client A - 11/1/2022 - 450
4
Client B
12/1/2022
700
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
2
600700150450350
600700
1300
​
Client B - 12/1/2022 - 700
5
Client C
12/1/2022
450
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
2
650450200800350
650450
1100
​
Client C - 12/1/2022 - 450
6
Client A
12/1/2022
900
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
2
450900100500350
450900
1350
​
Client A - 12/1/2022 - 900
7
Client A
1/1/2023
100
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
3
450900100500350
450900100
1450
​
Client A - 1/1/2023 - 100
8
Client B
1/1/2023
150
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
3
600700150450350
600700150
1450
​
Client B - 1/1/2023 - 150
9
Client C
1/1/2023
200
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
3
650450200800350
650450200
1300
​
Client C - 1/1/2023 - 200
10
Client A
2/1/2023
500
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
4
450900100500350
450900100500
1950
​
Client A - 2/1/2023 - 500
11
Client B
2/1/2023
450
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
4
600700150450350
600700150450
1900
​
Client B - 2/1/2023 - 450
12
Client C
2/1/2023
800
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
4
650450200800350
650450200800
2100
​
Client C - 2/1/2023 - 800
13
Client A
3/1/2023
350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
Client A - 11/1/2022 - 450
Client A - 12/1/2022 - 900
Client A - 1/1/2023 - 100
Client A - 2/1/2023 - 500
Client A - 3/1/2023 - 350
5
450900100500350
450900100500350
2300
​
Client A - 3/1/2023 - 350
14
Client B
3/1/2023
350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
Client B - 11/1/2022 - 600
Client B - 12/1/2022 - 700
Client B - 1/1/2023 - 150
Client B - 2/1/2023 - 450
Client B - 3/1/2023 - 350
5
600700150450350
600700150450350
2250
​
Client B - 3/1/2023 - 350
15
Client C
3/1/2023
350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
Client C - 11/1/2022 - 650
Client C - 12/1/2022 - 450
Client C - 1/1/2023 - 200
Client C - 2/1/2023 - 800
Client C - 3/1/2023 - 350
5
650450200800350
650450200800350
2450
​
Client C - 3/1/2023 - 350
There are no rows in this table
⁠
S

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.