Data Studio
2.6K members online now
2.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Combine fields for Geocoding

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a connection to a SQL database with two fields called 'latitude' and 'longitude'. Now I want to create a map showing several locations as points. What formula do I have to use to create a new field 'latitude, longitude'?

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Daniel D
January 2017

Combine fields for Geocoding

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Daniel D,

 

You could bring this date into a single field using CONCAT(X, Y) where X and Y are your latitude and longitude. Whether that would be read correctly for a map chart I am not certain!

 

Hope that helps,

Ben

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Daniel D
January 2017

Combine fields for Geocoding

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Daniel D,

 

You could bring this date into a single field using CONCAT(X, Y) where X and Y are your latitude and longitude. Whether that would be read correctly for a map chart I am not certain!

 

Hope that helps,

Ben