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

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
Client
Date
Ad Spend
step01
step02
step03
step04
step05
step06
step07
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
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
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
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
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
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
There are no rows in this table
⁠
S

Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.