Forum Discussion

danielrabinovit's avatar
danielrabinovit
Cloud Apps
06-23-2025
Solved

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.

administration
  • MikeGre's avatar
    MikeGre
    06-23-2025

    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

3 Replies

  • MikeGre's avatar
    MikeGre
    ETL
    06-23-2025

    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

  • DRay's avatar
    DRay
    Admin
    06-26-2025

    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.

  • danielrabinovit's avatar
    danielrabinovit
    Cloud Apps
    06-27-2025

    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!