Can you provide a sample workbook? it should achievable via tooltip with worksheet, but need a sample workbook to show how to.
I agree with Zhouyi Zhang that In concept it should probably be doable. For Question 1, part 1, an LOD calculation is likely to help with that issue.
For Question 1, part 2, there is a method for creating a string of multiple data to be displayed, which could resolve that issue: Tableau Public
Question 2 is likely doable using a Top 5 filter with Export Values using Viz in Tooltip feature.
But a workbook with real (preferably) or mocked-up is needed.
Conceptually, you'd get something like this that was developed in Tableau Sample Superstore data:
Thank you both for replying! I have attached the workbook.
Since I will be needing to do the same thing for another data set, if you manage to resolve Question 1 and Question 2 in the workbook, please do list out the steps you took so that I can recreate the process elsewhere. Much appreciated!
Metropolitan Areas.twbx 314.1 KB
see the attached
as for the first question - this will get the total value of exports bu city
this will rank them
I hard coded this to 5 (could be a parameter or other value and set it across (that is across the geo - city1 )
the detail sheet filtered will look like sparse data I just put the rank number in for testing - you can make it detail so it doesn't show
not the tooltip on the map look like this put in the detail sheet but set the "Filter" just to City 1 and extend the width
now it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Metropolitan Areas_v10.5.twbx 298.8 KB
My first post focused on the ranking problem -
to your first question
if you put the simple export value on the the size you will get the stacked dots - after all they are in the same city
- you can separate the marks by using a jitter
see Sarah Battersby paper on that at
Thank you for the reply. This is very helpful. I followed your steps and resolved Question 2. I think this method of ranking them in a table is fine--no pie chart needed for now.
However, Question 1 is still not resolved--I wanted to be able to select a few different industries in the "NAICS Description" Filter, and have the map show me the summed Export Value for only the selected industries. How would I do this?
if you saw my last post it speaks to jittering point - suggest you evaluate that
- you are working with a lot of codes that at tied to cities - cites are a geo point not a shape - you can move around the single point with the process Sarah details -