Why doesn't my Map in DOMO have colors?

Options

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?

Tagged:

Best Answer

Answers

  • ColemenWilson
    Options

    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

    If I solved your problem, please select "yes" above

  • ColemenWilson
    Options

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

    If I solved your problem, please select "yes" above

  • Lu_zhang
    Lu_zhang Member
    Options

    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
    Lu_zhang Member
    Options

    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
    Answer ✓
    Options

    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:

    If I solved your problem, please select "yes" above