KNOWLEDGE BASE

Tableau does not recognize the following 2 Japanese cities as county: 1. 丹波篠山市 (Tamba-Sasayama, Hyōgo) 2. 那珂川市 (Nakagawa, Fukuoka)


Published: 30 Oct 2023
Last Modified Date: 01 Nov 2023

Issue

Tableau does not recognize the following 2 Japanese cities as county: 1. 丹波篠山市 (Tamba-Sasayama, Hyōgo)- city changed its name from 篠山市 to 丹波篠山市 in May 2019. 2. 那珂川市 (Nakagawa, Fukuoka)- city founded on October 2018, from 筑紫郡那珂川町.

Environment

  • Tableau Desktop

Resolution

Workaround

1. Create a calculated field to change city names from new names to old names as below:
CASE [string]
WHEN "丹波篠山市" THEN "篠山市"
WHEN "那珂川市" THEN "筑紫郡那珂川町"
ELSE [string]
END
2. Assign county geographic role to a new field.

Cause

This issue is being investigated and you can follow this Known Issue on the Salesforce site: W-14376669.
Did this article resolve the issue?