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
DB Brussels - Paris

Applying a filter logic to calculate driving time

thisTable.Filter(
periods.Contains(thisRow.periods) and
occupation.Contains([Driving ]) and
stopTypes.Contains([Border crossing]).Not()).WithName(base,
If(
base.Count() = 1,
base.countDown,
base.delta)).First()
Name
stopTypes
occupation
timeSlots
periods
perPeriod
1
Action 1 Dep → Dépot Bus Partner
Garage
Driving
​06:30
Driving period 1
15 mins
2
Action 2 Arr → Brussel North
Station
Break 1
​06:45
Driver's break
​
3
Action 3 Dep → Brussel North
Station
Driving
​07:00
Driving period 2
4 hrs 15 mins
4
Action 4 Arr → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
​08:30
Driving period 2
4 hrs 15 mins
5
Action 5 Dep → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
​08:30
Driving period 2
4 hrs 15 mins
6
Action 6 Arr → Paris (Bercy Seine)
Station
Break 2
​11:15
Driver's break
​
7
Action 7 Dep → Paris (Bercy Seine)
Station
Driving
​12:30
Driving period 3
4 hrs
8
Action 8 Arr → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
​15:15
Driving period 3
4 hrs
9
Action 9 Dep → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
​15:15
Driving period 3
4 hrs
10
Action 10 Arr → Brussel North
Station
Break 3
​16:30
Driver's break
​
11
Action 11 Dep → Brussel North
Station
Driving
​16:45
Driving period 4
15 mins
12
Action 12 Arr → Dépot Bus Partner
Garage
Driving
​17:00
Driving period 4
15 mins
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.