I couldn't find the original thread, so maybe this has been answered:
I want something like this, but even simpler - I have a list of places with my own lat and longs (not generated) and want to plot a 100 mile circle around each of them. I can see the above example has custom geocoding, but I don't know how to create that.
Thanks Shawn - this is useful - I didn't see any ref to custom geocoding - is this somewhere else?
Hi Alex, I really don't remember how Richard did this, though I'm pretty sure it was an early iteration of what became TabGeoHack. But I'm sure when he gets up in a few hours (3:15a.m. NZ time) he'll chime in.
Here's TabGeoHack & ShapeToTab, and the latest version of his work is posted in this Viz Talks. It's all interconnected giving you different features and benefits, depending on which technique you use. You might want to check them out. FYI: He also has a MakeCircles utility he might be willing to share with you, which might be exactly what you're looking for.
Okay, as I didn't need anything too complicated, I created an xlsx and tableau file to do this automatically. Add your locations (with lat,long) in the locations sheet. The circles sheet will now have the rows you need for the radius based circles. If you have more than 20 locations, you just need to copy the cells down (no need to paste 0-360, this column uses a calculation, add 361 rows per location).
You can then open the tableau file with the extract (data needs to be extracted), and point the source at your new xlsx file. The custom SQL tab has the new code you need. You can change the radius of the circles in row 1. If you want to add more, just copy down another union all section, and edit the cell ref to the new radius.
Hi Alex, excellent work!
I was able to apply your templates to my Excel Data which has over 400 locations .
I was wondering if its possible to "flag" circles whose borders intersect (possibly with a label or diffenrent color)?
Can someone please help? I also need something like this. I need to increase the size of the bubbles on my charts but I don't need maps. I also have my own fields for columns and row.
This is excellent, and has really helped me out. I am at a bit of a sticking point however, and can't seem to figure out the next step to take. I have applied your data to our store locations, and built adjustable radius around each of them. In a Seperate viz, I have created a map of leads by zip code.
What I really want to do is figure out how to drop these on top of each other, but I just can't seem to figure out how to do that. If I could put in custom data layering, that would work, but I haven't found a way to do that. The only other option I can find is to build custom geocoded polygons... Is that my only other option?
Hi there, tableau fellows!
Thank all of you for those neat solution for concentric circles on the map. But your further help is still needed.
I want to laid the circle over a filled map with some countries on it in exactly the same manner it was done in Richard Leeke's New Version of (Concentric) Circles (which I failed to open with neither Tableau Public 9.0 nor Desktop 9.1).
So, I have an xlsx-file with the list of countries and its ISO indicies. All the rest columns are for the cirle drawing (i.e. degrees, their path numbers and coordinates of the center of the circle for all calculations).
I also enclose a tableau workbook to make the idea more clear - to join two existed tabs/sheets on one map.
Waiting for your solutions.
I am relatively new to Tableau.
I am looking at creating some thing similar to what this. I did download the workbook and had a quick look at it and was unable to understand what is going through.
What I want is to give the user the capablity of choosing the radius as a parameter and see what is the range it covers from that point.
Is there a way that we can see a step by step instruction on how this was created?
Thanks for your help.
I replied to the other thread you started.
Amazing stuff and I've downloaded the file but I can't figure out how the radius parameter is actually working. I tried to increase the radius to include values all the way up to 10 and it will only work for values 1 - 6 (as originally designed). I've dissected the workbook and can't figure out why the radius parameter even works (for values 1 - 6), and then on the flip side, why it won't work for any other values. What am I missing?
Wait, I see it now. Custom geo-coding. I like it but now realize I'm going to have a much harder time than I hoped trying to do this for my ~4000 dynamic locations.
Maybe Tableau 10.0 will tackle this
2 of 2 people found this helpful
I couldn't remember either to start with - but Alex is quite right that I used custom geocoding and also quite right that that won't work for 4,000 dynamic locations.
[And by the way, thanks for the ping, Shawn - I don't seem to receive notification emails for comments on my threads any more. But I have just noticed that there is a notifications icon at the top of the forum page with a huge long list of notifications dating back months, I never knew that existed. I'l have to try to find the time to wade through them and see if any of them are still relevant...]