Why doesn't my Map in DOMO have colors?

Lu_zhang

Is it because I have the Province/fsa name in 省份，that is a Chinese version province list?

How can I change them in a batch? Can DOMO recognize the Chinese words? How does DOMO recognize the Chinese words?

ColemenWilson

I've noticed the issue with "@" someone, when it isn't working I just refresh the page and it usually works at that point. Kind of annoying.

For the ETL you'll need to:

1. Bring the data table into Domo (as a webform is probably easiest https://domo-support.domo.com/s/article/360043436813?language=en_US )
2. Join it with your data:
   https://www.youtube.com/watch?v=2ndqQitova4

ColemenWilson

I would use an ETL to convert the chinese characters into English, which Domo should recognize:

Chinese	English
北京市	Beijing
天津市	Tianjin
上海市	Shanghai
重庆市	Chongqing
河北省	Hebei Province
山西省	Shanxi Province
辽宁省	Liaoning Province
吉林省	Jilin Province
黑龙江省	Heilongjiang Province
江苏省	Jiangsu Province
浙江省	Zhejiang Province
安徽省	Anhui Province
福建省	Fujian Province
江西省	Jiangxi Province
山东省	Shandong Province
河南省	Henan Province
湖北省	Hubei Province
湖南省	Hunan Province
广东省	Guangdong Province
海南省	Hainan Province
四川省	Sichuan Province
贵州省	Guizhou Province
云南省	Yunnan Province
陕西省	Shaanxi Province
甘肃省	Gansu Province
青海省	Qinghai Province
台湾省	Taiwan Province
内蒙古自治区	Inner Mongolia Autonomous Region
广西壮族自治区	Guangxi Zhuang Autonomous Region
西藏自治区	Tibet Autonomous Region
宁夏回族自治区	Ningxia Hui Autonomous Region
新疆维吾尔自治区	Xinjiang Uygur Autonomous Region
香港特别行政区	Hong Kong Special Administrative Region
澳门特别行政区	Macau Special Administrative Region

ColemenWilson

I just tested and you will actually need to remove "province" , "autonomous region" and "Special Administrative Region" from the english names.

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/96232#Comment_96232

It‘s you again. thanks for your help again.

can you pls show me how to use ETL to convert? I do not quite understand how to do it. thanks

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/96228#Comment_96228

can you pls show me how to use ETL to convert? I do not quite understand how to do it. thanks

@ColemenWilson

another question. when I want to @ someone, It always doesn't pop out the name list. I appears like ' @Colemen', not like ' @ColemenWilson '. I need to try many times then get the one just for one time at random. Do you know why? do you know how to handle it? thank you.

ColemenWilson

I've noticed the issue with "@" someone, when it isn't working I just refresh the page and it usually works at that point. Kind of annoying.

For the ETL you'll need to:

1. Bring the data table into Domo (as a webform is probably easiest https://domo-support.domo.com/s/article/360043436813?language=en_US )
2. Join it with your data:
   https://www.youtube.com/watch?v=2ndqQitova4