Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Average Distance Between Locations

Maltaleb001
6 - Meteoroid

Hello everyone,

 

First and foremost, I am beginner in spatial analysis and there may be easy solution that I am not aware of. However, I have around 50 locations and I want to calculate the average distance between them. What I want to answer exactly is ( In average, there is a location in every XX Km/mi).

 

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @Maltaleb001 ,

 

I could think of three different ways that you can do that, not sure however which is the best one or which will yield the most accurate results. I have annotated the workflow to explain what each part does, hopefully one of them is close to what you are looking for.

 

AngelosPachis_0-1621635935989.png

 

Cheers,

 

Angelos

Maltaleb001
6 - Meteoroid

Very interesting @

 

Thank you very much for the solutions, super helpful! 

 

I did the following, and the average distance I got is almost identical to your 3rd solution.

 

Maltaleb001_0-1621637554903.png

Appreciated your help.

Labels