Last Modified Date: 19 Oct 2022
Environment
- Tableau Desktop
Resolution
Create a calculated field to convert the nine-digit ZIP codes to five-digit ZIP codes.
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog box that opens, do the following and then click OK:
- Name the calculated field. For example, Short ZIP Code.
- In the formula field, type the following, where ZIP Code is the name of the dimension:
LEFT([ZIP Code], 5)
- Right-click Short ZIP Code and select Geographic Role > ZIP Code/Postcode.
- Use the new Short ZIP Code Short field instead of the original ZIP Code dimension in any map view.
Cause
When geocoding, Tableau Desktop only recognizes five-digit ZIP codes.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials