OK, I think I’ve got two solutions. I’ve put up a workbook here for you; please let me know if you can’t download it.
1. Instead of mapping country/state, you could make a dual axis map with State on one layer and State2 on another layer. This is on Sheet 3 of the workbook I posted, and gives you the granularity of seeing where your items are from in more detail outside the US. (I also changed the color scale to 1-100, so that the 1300 items in Brazil didn’t wash everything else out.)
2. You can do a country/state dual axis map with Country on one layer and State2 on the other layer. This is on Sheet 5. You’d do this by right clicking Country > Create Calculated Field, and then entering this formula in the box that comes up:
IF [Country] = “United States” THEN “”
ELSE [Country]
END
This tells Tableau that if the column Country contains the word United States, put nothing in the new column, and if the column Country contains anything else, copy that value over. Very similar to “Create column based on this column” in OpenRefine, but without having to make a new column in your spreadsheet.
2 Comments
Maeve Kane
OK, I think I’ve got two solutions. I’ve put up a workbook here for you; please let me know if you can’t download it.
1. Instead of mapping country/state, you could make a dual axis map with State on one layer and State2 on another layer. This is on Sheet 3 of the workbook I posted, and gives you the granularity of seeing where your items are from in more detail outside the US. (I also changed the color scale to 1-100, so that the 1300 items in Brazil didn’t wash everything else out.)
2. You can do a country/state dual axis map with Country on one layer and State2 on the other layer. This is on Sheet 5. You’d do this by right clicking Country > Create Calculated Field, and then entering this formula in the box that comes up:
IF [Country] = “United States” THEN “”
ELSE [Country]
END
This tells Tableau that if the column Country contains the word United States, put nothing in the new column, and if the column Country contains anything else, copy that value over. Very similar to “Create column based on this column” in OpenRefine, but without having to make a new column in your spreadsheet.
I hope that helps, lmk if you get stuck!
scarlatte28
The directions make sense but I’m having trouble getting the solution to work for me. Can you help me with this in class?