I’m still not so familiar to the nodes and their functions…
I would like to calculate the percentage of the OTD (when the actual time is > = planned time)then it is ontime.
Which Node should I use so I could calculate the percentage?
(When actual_eta is bigger than planned_eta than its ontime and needs to divide all the bookings)
I have a column, which contains wether it is ontime or delay. I thought about to count the value but I have problem knowing how to count only the number of ontime and divide it with all rows)
thanks in advance!
truck.knwf (3.6 MB)