RedditPP Mascot

RedditPP

r/tableau • … • u/NFL_MVP_Kevin_White

Distance between unrelated points

I have two unrelated datasets mapped onto a map as separate layers- county centroids and facility locations. They are both spatial fields created using MAKEPOINT and their respective Latitude+Longitude values.

When I try to use the DISTANCE function to calculate the distance between a selected location and county centroids, it brings in a COLLECT for the facility location. The end result is an error that says “unknown function distance called”.

Is what I’m trying to do impossible without related the tables some how? I don’t feel like tracking down FIPS codes for both tables and linking them that way.

— 0