Help Needed: Assign Biker Based on Availability & Travel Time

Question

Hi everyone,

I'm building a delivery simulation in Alteryx and need help designing logic to assign each new delivery order to the next available biker, based on the time it will take to complete the shipment

which I already have as a column called Estimated time to travel(in mins).

Scenario:
I currently have 4 bikers

SLA: Each order should be delivered within 2 hours (120 minutes) from the order time

Each biker starts as available at 0 minutes, and becomes unavailable until the time it takes to complete their assigned delivery

My Goal:

1.Assign it to the next available biker (someone who is free at or before the order time)
2.If no biker is available, mark the order as Staged and track how long it waits before someone is free
3.Track whether the shipment was delivered within SLA (120 mins)

Order Sheet.xlsx

JenilShah · Answer

Hi Aatalai,

They need to come back to store, In Estimated time, coming back to store time is added.

aatalai · Answer

@JenilShah when the estimated time to travel is completed (estimated time to travel) do they need to return or can they go straight onto the next task?

KGT · Answer

You may want to check out the sample at "Help > Sample Workflows > Use Scripting.... > Build a macro > Assign Supply to Demand". It uses an iterative macro to assign orders based on criteria.