Finding Optimal Route using Lat Long

[Prasahanthshetti]

Hi Please help me at the earliest 

I'm trying to prove my hypothesis: My delivery executives are taking inefficient routes and ending up taking long distance to delivery 
I have following columns 
1. Create time with date and time 
2. Executive Id 
3. Lat, Long of customer Location 
4. Lat, Long of Executive starting point 
I need to get the following insights 
a. The distance travelled by each executive per week following the current system( total distance from start>A>B>C in a week) 
b. The optimal distance he can travel for same locations 

c. Difference between normal distance and optimal distance 

Final output should contain 
1. ID 

2. Total distance in Km 
3. Week number 
4. Optimal distance in Km
5. Delta 

please help me out or guide me to right resources 

[FrederikE]

Hey @Prasahanthshetti,

Here is an example workflow that does something similar (simplified). 

Also you might want to check solutions of some weekly challenges  - there are a few which do smth. similar (Nr. 6 and 299 are the ones that came to my mind) https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275

Otherwise Check out the Spatial Part of the Advanced Cert. Learning Path: https://community.alteryx.com/t5/Learning-Paths/Advanced-Certification-Learning-Path/ta-p/660137#don...

this is helpful to understand the different spatial tools. 

If you require any more precise help, please share a dummy-dataset.