1 of 1 people found this helpful
You can import custom geocoding. Refer to the below link:
Alternatively you can create a custom file with 2 columns : country ,region with corresponding data and join that with your main table on country key.
Thanks but I am sorry as I am unable to understand how this can be used to achieve my requirement?
Are you saying my requirement cannot be achieved unless it is incorporated in the source itself?
You have mentioned in your query or question that "However, I do not have region wise split of the countries."
if the data itself does not have the region level granularity where would the tableau get it from.
if you have the data then LOD expressions can be used to get the regional level details.
Hope you understand.
You can do this either by creating a group on your countries field and renaming the groups.
Or create a calculated field that will set them. You can group multiple countries into an if statement if you like by separating them by an 'OR'
if country = 'Country1' or country = 'Country2' then 'Region1
elseif country = 'Country3' then 'Region2