CODEWITHSUNDEEP
looker-studio
Raffael
Raffael

Reputation: 20045

How to display points defined via latitude and longitude on a Bubble Map?

SELECT
  name,
  latitude,
  longitude,
  CONCAT(latitude,',',longitude) AS location
FROM
  `bigquery-public-data.ghcn_m.ghcnm_tavg_stations`
LIMIT
  1000

I'd like to display those stations on a Bubble Map in Data Studio.

But it doesn't accept location as the location dimension. How do I have to go about this?

Upvotes: 0

Views: 726

Answers (1)

Sergey Geron
Sergey Geron

Reputation: 10172

Strange... It worked for me. I created a table like this:

CREATE TABLE test.test 
as
SELECT
  name,
  latitude,
  longitude,
  CONCAT(latitude,',',longitude) AS location
FROM
  `bigquery-public-data.ghcn_m.ghcnm_tavg_stations`
LIMIT
  1000

then used it as a datasource for the Datastudio Report. Make sure that you selected the Type of the field as Latitude, Longitude and pressed Refresh Data enter image description here enter image description here

Upvotes: 1

Related Questions