Map Help

Hi everyone,

I am trying to create a heatmap style visual using latitude and longitude. I have a column called location that has data that looks like this -26.27389, 28.127951. Is there something I am misunderstanding when trying to input this as location data?

Thanks.

danielrabinovit

Posted 1 year ago·Last reply 1 year ago

3 comments

danielrabinovit

OP1 year ago · Edited

Hi everyone,

the reason I did it as the method described above is because that is how the documentation on the website tells me how to do it. (See screenshot below). The solution did work, but it was confusing.

As always, thanks for the help!

DRay

·1 year ago

Hello danielrabinovit,

I’m following up to see if the solution offered by MikeGre worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

Michalis Gregoriou

·1 year ago

Hi danielrabinovit

You should try to split your current column in 2 separate columns (eg. One for Latitude and one for Longitude) on your Schema.

Assuming your current column is a text, you can use something like:

strparts(current_column,',',1)

strparts(current_column,',',2)

Then adding them using Scatter Map widget type should visualize what you need!

Hope this helps