Last Modified Date: 12 Mar 2018
AnswerTableau Desktop recognizes only the first three digits of Japanese postal codes. The following instructions demonstrate how a calculated field can be used to display only the first three digits of a seven-digit postal code.
- In Tableau Desktop, connect to a data source that has seven-digit Japanese postal codes.
- In the Data pane, right-click the postal code dimension and select Change Data Type > String.
- Click Analysis > Create Calculated Field and create a calculated field to split the first 3 digits from the remainder of the postal code. For example:
- Right-click the new calculated field and select Geographic Role > ZIP Code/Postcode.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials