Last Modified Date: 07 Apr 2017
Step 1: Change the Data Type and Geographic role
- Download and open the FIPS 5 County Codes example workbook.
- Right-click County FIPS 5 and select Change Data Type > String.
- Right-click County FIPS 5 again and select Geographic Role > County.
Step 2: Build the view
- Drag State to Detail on the Marks card.
- Drag County FIPS 5 to Detail on the Marks card.
- Click the Marks card drop down menu and select Filled Map.
- (Optional) Drag County to Label.
The resulting map view will show the counties for the state of New York. To view these steps in action, see the video below:
Additional InformationSome of your county codes may contain leading zeros that might be removed automatically by Tableau. For example, the county code of Autauga in state Alabama is 01001 and might show as 1001 in Tableau.
- To ensure the zeros are kept, use a calculated field similar to the following: Right("00" + Str([County FIPS 5]),5)
- If you are using Excel as your data source, add the following calculation: =
TEXT(A1,"00000"to get a 5-digit code even with leading zeros.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials