CODEWITHSUNDEEP
looker-studiogeomap
ERJAN
ERJAN

Reputation: 24508

How can I make a Geo Chart display one specific country and its regions in Google Data Studio?

A Geo 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 ??

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:

Google Data Studio Report

Upvotes: 1

Views: 5869

Answers (1)

Nimantha
Nimantha

Reputation: 6482

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:

Upvotes: 1

Related Questions