Yes, I did try adding them, but it didn't seem to plot correctly. The steps I took were:
1. Add the custom geocoding that included the following fields:
- Postsecondary Institution Name
2. I then loaded it using the "Import Custom Geocoding" tool, which worked, it all loaded.
3. I then tried to map the universities into Tableau and link the Postsecondary Instiution name field to the one listed in my Custom Geocoding options in my data type, but they would not appear on a map. The map would show up blank.
I will try it out on Monday.
Lauren, so your first issue is that Longitude is misspelled in your Excel data, Tableau doesn't recognize it. I gave it the right geographic role when connecting to the data. The next thing I did was to move your [UNITID] field from Measures (where Tableau defaults all # types) to the Dimension pane, I'm assuming this is a unique identifier for each university. And finally I made sure to use your lat/longs and NOT the generated ones. Your viz looks like this:
I dropped city on the color shelf just to show you that you are getting multiple universities within each city. Even though you are using your own lat/longs Tableau will recognize and add other geographies in it's database as long as they exist in your database. (Some of your data doesn't have counties and states for some universities at the end of the list.)
Anyway the attached 9.3 workbook should get you started.
EDIT: There is no need to add custom geographies here. I just used a direct connections to your Excel file and then used the correct lat/long (the one coming from the Excel file). After that Tableau is smart enough to figure most everything else out.
Universities.twbx 99.4 KB
1 of 1 people found this helpful
Thank you very much Shawn! This is working great for me on my end, too. I appreciate the help.
So glad! And you are of course quite welcome. Keep asking questions, it's the lifeblood of our community.