问题描述
地理位置地图通常会显示整个世界.
如何根据我的数据显示一个国家的地区并为其着色?
我又如何将数据分组到一个表中,以便Data Studio可以真正代表我所在的国家/地区?
例如我有3个国家/地区,每个国家/地区都有帐户数,我可以在哪个列中输入我所在国家/地区的区域数据?
国家帐号编号区域俄罗斯324 ??哈萨克斯坦5785?美国2342 ??
我添加了一个报告,Data Studio可以通过国家/地区代码识别国家/地区,但目前尚不清楚如何通过数字突出显示区域.
Geomap chart usually shows entire world.
How to show one country's region and color them according to my data?
Also how can I group my data in a table so data studio can actually represent regions of my country?
e.g. i have 3 countries and number of accounts in each country, in what column can i put regional data for my country?
country account_number region
russia 324 ??
kazakhstan 5785 ??
america 2342 ??
EDIT:
i have added a report , data studio recognizes the country by country code, but from there it's not clear how to highlight regions by numbers.
@Nimantha
One way it can be achieved is by using:
- Chart Type: Google Maps
- Bubble Location:
region
- Bubble Colour:
country
- Metric:
metric
Created an Editable Google Sheet with the sample data below with some random values for the metric
field as well as adding a few values for the region
field:
+---------------+----------------+-----------------+--------+
| country | account_number | region | metric |
+---------------+----------------+-----------------+--------+
| Russia | 324 |Moscow | 54 |
| Russia | 325 |Saint Petersburg | 36 |
| Russia | 326 |Krasnodar Krai | 14 |
| Kazakhstan | 5785 |Almaty | 31 |
| Kazakhstan | 5786 |Astana | 57 |
| Kazakhstan | 5787 |Kyzylorda | 58 |
| United States | 2342 |New York | 28 |
| United States | 2343 |California | 99 |
| United States | 2344 |Texas | 30 |
+---------------+----------------+-----------------+--------+
Editable Google Data Studio Report as well as a GIF to elaborate (Feel free to edit and test out the chart):
这篇关于如何使地理地图在Data Studio中显示一个特定的国家或地区?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!