Help Needed: Assign Biker Based on Availability & Travel Time

[JenilShah]

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)

[caltang]

What have you done so far in your own workflow? Attach it and let us see. Then we can better advise.

[KGT]

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.

[aatalai]

@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?

[JenilShah]

Hi Aatalai,

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