Hi @giacomo ,
Is your aim to minimise the distance each driver has to drive off course while they are heading from the origin location back to their homes?
A small implication you might face here is that to answer that question accurately you need access to drivetime data, and not all users have access to them. With the distance tool, you can estimate the distance between 2 points as the crow flies, but that will give you a false impression of which destination is nearest.
Hope that kind of makes sense.
Cheers,
Angelos
Hi @giacomo,
In order to optimize your route, you need to have an objective function. For instance, this could be to minimize total distance. This objective function will be subject to several constrains: max amount of trips each driver can take (4) etc.
This video could be helpful to help you formulate the problem: https://community.alteryx.com/t5/Videos/Introduction-to-Prescriptive-Optimization/td-p/148048
Best!
Thanks for your reply Angelos, I'm willing to accept that distance as the crow flies is not the same as driving distance. I still feel that the optimization tool may still produce better, more optimal, results than the iterative macro solution I cooked up. Thus, I'm seeking help on the optimization tool because the set up of the tool isn't very intuitive to me.