How would you like percent of total to be displayed?
Color is the only value that can be represented on a simple filled field map and that seems to already be occupied by your [Measure] field.
I was thinking of using color to indicate the attribute rather than percent of total. So each county would be filled with a single color based on the top heating fuel source. Does that make sense?
That's exactly what I was going for. I don't know why I couldn't figure out the partitioning.
No problem, glad to help :-)
Hi Aaron, Chris,
I'm struggling with the same challenge as Chris; trying to show top N different categories in a map. Would you care to share your final solution in the thread, as I'm having trouble opening the solution file.
Many thanks in advance!
Create a calculated field using Index() and put it on the details shelf. Go to "edit table calculation" and select "advanced" under "compute using:"
Then move the appropriate partitions to addressing and put them in the appropriate order (in my case: state, county, measure) and sort according to the appropriate field.
Then set the table calculation at the level "deepest" restarting at whatever geographic level you want to map.
Finally, put the Index calculation on the filters shelf and set it to 1.
If you have any problems attach a worksheet and I'll take a look.
Many thanks, this approach seems to be the right one: I have managed to get the desired result in a table format, but not yet on the world map, where Tableau will visualize multiple items (flight routes) for every 'index' point selected as filter.
I have attached my sample file, and would very much appreciate help! The file contains two worksheets; one with the world map, and one with the data in table format. The selection of flight routes as filtered in the second worksheet "O&D ranking in table" is the selection of routes I also want to visualize in the world map.
Many thanks in advance and best regards,
Network Maps Tableau.twbx 64.2 KB
I assume you want to show the top N routes (by capacity) for each airline? The problem as I see it is that Tableau wants to partition it by lat, long, and order. I don't know how you can take those dimensions off the view and still get the view you're tying to build. Perhaps you could load custom geocodes for the airports and then build a point or filled map, but then you wouldn't be able to show the paths.
Sorry I can't be more help. Maybe someone with more chops could figure it out.