1 of 1 people found this helpful
In your original view as described, what's happening is that Tableau is drawing 144 marks, one for each combination of State and Category. For each state, the displayed sum of Sales on the choropleth map is for the first sorted mark, which is for the Furniture Category, so the amounts that you see are not the actual totals across all categories. Since each state has the same lat/long center point, all the labels are draw on top of one another.
One technique would be to do your own geocoding and generate your own locations for labels, and set up a dual-axis chart.
The alternative is to use table calcs, which are a general solution to problems where we want to have the data at one level of detail (State and Category) while the display is at another level of detail (State). A TOTAL(SUM([Sales])) table calc with Compute Using set to Category will generate a per-state total of sales. Generating the label takes a bit more work, I set up two calcs. One uses PREVIOUS_VALUE() - Tableau's one iterative function - to generate a label, then another calc uses a LOOKUP on the first calc to get the last label value for each state. The Compute Using for these is also set to Category.
Finally, I also added an instance of the Category Label on the Filters Shelf to Exclude Null values, this reduces the view back down to only displaying 48 marks, one for each state.
I am facing a similar issue related to this. This is my scenario :
I have two tables :
TABLE 1 contains the following fields : MCC , MNC , Total Volume
TABLE 2 contains the following fields : MCC , MNC , Country , Network Name
Both of the tables are mapped with MCC and MNC fields to determine which Network under a particular country has how much volume usage.
Now i plotted a filled map on basis of Country and Total volume . It shows me Total Volume for each country. Now i want the following things to be done which i don't have any clue of doing since i am a beginner to this:
1. Show bar chart in tool tip showing the different Network Contribution of volume for that particular country when ever i click on any filled map location of a country. for eg :-
Country : India
Fascel : ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 75 %
Airtel : ||||||||||||||||||||||||||| 25 %
2. Show in tool tip normal text for different Network Contribution of volume for that particular country when ever i click on any filled map location of a country. for eg :-
Country : India
Network Contribution :
Fascel : 70 M.B
Airtel : 30 M.B
Total Volume : 100 M.B
3. Add a filter action when ever on click on and filled map location of country , then one more dashboard should open showing the network contribution of volume towards the particular country in horizontal bar chart. But here the functionality of tool tip as mentioned in point 1 & 2 should not go away.
Will be very much helpful if u give your expertise assistance on this since this functionality is required on an urgent basis:
Thanks & Regards,
Could you please attach the packaged workbook of the same so that I can work on it and attach the response back.
To achieve your first functionality I suggest you follow the following link.
Hello Paramesh ,
Please find the sample attached workbook with all the data you required. And regarding the first functionality i had gone through this links on before hand but the problem in here is that i need to create %NetworkNameUsage calculated field which is not possible since there are 1000's of networks and i need not to create calculated field for each network manually.
Thanks & Regards,
Suhrid R. Ghosh
NetwokData Usage.twbx.zip 753.0 KB