I played around with this some more, and was able to finally kinda-sorta get it to work. I joined my data table to the municipal boundary shapefile, then converted that to points, then exported the attribute table to Excel and imported that to Tableau. If I use the points table as the sole data source, about half of the time, Tableau will draw the polygons and let me drag Category 1, 2, 3, etc. to Color and shade the filled polygons appropriately. The other half of the time, following the same steps, the viz disappears, the polygons draw weirdly, or the polygons draw only until I try to add something to color. I've also saved the two data sources separately, and tried joining the data table to the boundary points table in Tableau. The joins don't work and it gives me all Null values.
I don't think I will be able to get it to dynamically change the map in the dashboard, so I'm going to try to use a parameter to switch between the map worksheets instead. example
If I manage to figure anything else out, I will add an update.
1 of 1 people found this helpful
Is there any chance you can supply the shape files and some fake data ?
I might be able to help, but I'm not quite sure what you're after.
Hi Chris, thanks for your reply. I found an awesome workbook with an example of what I am looking to do, in this thread:
Their dashboard has a dynamic custom map that changes depending on which variable is selected from the drop-down menu at top right.
I would like to do the same thing, but each variable would have a different color ramp, versus all of them using the same color ramp. I kept at my initial problem and was able to get the custom geocoding to work, so now I have one worksheet with a 10-county municipality map, with each municipality color-coded by a variable. Right now I am stuck on how to make the map change colors dynamically, based off of the variables in the drop-down menu. Can I set up a parameter to do this somehow?
I don't think you need a parameter to make this work.
Check the attachment (and the awesome datafile )
Sheet2 - only has Value on Color, so everything is a shade of green (or that ONE colour that you choose)
Sheet3 - I converted Value to Discrete, so I can put Measure & Value on Color and now I can have a completely different colour spectrum for each measure.
I've used the automagically assigned colours, so it might be a bit different when you try to assign the exact colours you want.
Let me know how you go
We are still on 9.0 but are getting upgraded this week. I'll look at your workbook once we're upgraded to 9.2, and see if I can replicate it. Will post back with more details! Thanks again for your help.
I forgot all about replying to this thread! I just wanted to post an update....it took some fiddling, but I was finally able to get that map to work. I ended up using this tool from Alteryx to convert my shapefile to Tableau: Alteryx Analytics Gallery It worked much better than the ET GeoWizards tool that I was using in ArcMap. Once I set up the custom shapes to draw properly, I ended up using a parameter+calculated field to control the map, so now the color range is automatically applied for the whole map, sort of like what you showed me in your workbook.
Thanks for your help!