Hi Ria.

Well yes, sort of. Question: Do you currently own a Tableau license? Or is this a hypothetical question?

--Shawn

OK, I fairly certain that Tableau only 'supports' US zipcodes, but if you have the latitude and longitude for your zipcodes then you won't have any trouble mapping them. Once you've done that, Richard has a workbook he developed to show/hide those marks based on a given radius -- not sure if he posted it or not. Let us know about the lat/long question.

--Shawn

Ria great! Good thing you posted the screen shot, because now I know that the first thing you're going to need to do is convert your lat/longs from deg/minutes to decimal degrees. You have two choices 1) Go to this KB article and work out the formula in your spread sheet or 2) Go to this page and use the Batch Converter.

When you get that done, post the excel file (delete any sensitive data, all we really need is City & the lat and long columns. What's your deadline for this? I ask because I believe Richard may be travelling and might not be available for a bit.

--Shawn

There's this thread: http://community.tableau.com/thread/117325#177737

Thanks Alex, that's probably just what he needs. I'd forgotten about that one.

--Shawn

Ria, did you take a look at that link Alex posted? Is that going to work for you? As to other data, it would be best if you post an Excel file with some sample data so we can see what you're talking about.

--Shawn

Ria, click the upper right link:

Then you can attach a file, down at the bottom.

--Shawn

Alex, I've attached his sample data with the lat/longs converted. You know your radius workbook, you want to do the honors?

Ria, the reason the Batch Converter didn't work for you was you misspelled "Latitude".

--Shawn

Like I mentioned, Richard is travelling. I just didn't know what his mode of transportation would be:

That's him, his daughter and his dog. Slow news day in NZ. But looks like great weather!

Richard said he'd check in here when he gets to shore.

--Shawn