7 Replies Latest reply on Jul 25, 2018 9:55 AM by Sebastian Sofariu

# Show distance in a Map

Hi everyone,

I have 100+ locations in the ocean and 25+ cities on the land (map attached). Cities on the land are major points of this analysis. The ultimate goal is to show the distance from cities (black circles) to locations in the ocean (colored triangles) in any manner. Simply to know how far these triangles are from adjacent main cities.

First I was planning on  creating buffer zones around each city using some threads but it eventually makes the whole dataset into an enormous number of rows enabling me to work on the viz. I have read some forum articles but did not really helped in my scenario. I am wondering if I can put a circle with 100km for each city. Would that work when zooming in and out options though?

I am interning at a non-profit and they just bought Tableau on my recommendation. So I must figure out this work for them.

THANK YOU VERY MUCH!!

• ###### 1. Re: Show distance in a Map

Hello Imesh,

I would suggest you start with the following discussion which will walk you step-by-step through the process of creating a radial filter.  Best way to learn Tableau is by doing!

If this resolves your question, please mark this response as correct so that others may find it useful in the future. Thx, Don

• ###### 2. Re: Show distance in a Map

This is the calculation that I use for distance in my mapping.  Maybe this can help you.  It is available in several threads.

3959 *ACOS

(

)

• ###### 3. Re: Show distance in a Map

Hi Don, Thank you very much.

I followed the steps and it works perfect. However, as shown in the attached map I have several center points (25+). I really do not understand how to use all cities and find the distance to adjacent points.

Is there any way I can put a circle with 100 miles radius on each center points I have?

Thank you!

• ###### 4. Re: Show distance in a Map

Hi Tim,

Thanks, and this formula works perfect!

But my problem is having several center points in my map. Not sure how to combine them yet.

• ###### 5. Re: Show distance in a Map

Take a look at my biz of BMV location on Tableau Public. All you need to do this is in that biz.   Just search for Tim Dines.

Sent from the iPhone of Timothy Dines.

• ###### 6. Re: Show distance in a Map

Just found

Joshua Milligan 's recent blog post that could help me to figure out how to proceed.

Joshua Milligan Thank you! I am a newbie in data viz and SQL. Is there any resource I can use if I do not have a SQL database? Is it a must to create the circle shapefile in a SQL database?

With appreciations!

• ###### 7. Re: Show distance in a Map

Hi Imesh,

The article below provide two possible workaround options.

Hope this help.