UK maps - long/lat

louiswatson
louiswatson Member
edited March 2023 in Datasets

I'm looking to setup a UK map which shows the location of each site around the UK using long/lat, is there a specific way that I need to format the long/lat numbers as no data is showing with the data that I currently have? Thankyou

Tagged:

Answers

  • @louiswatson Can you please share an example of the lat/long format that you are currently using?

  • Hey Michelle,

    Below is the current format of our long/lat figures:

    Long: -0.00880068

    Lat: 51.57307951


    Some figures have 8 decimals, some have 7.

    Cheers

  • Hi @louiswatson I do not see any issue with the Lat/Long format. What settings and chart type are you using?

  • I'm using the long/lat map, ideally I'd like the map to only show the UK. The symbols are also quite large, is there a way to make these into pins or something smaller?

  • @louiswatson I would recommend a couple things to fix this:

    1. Under the General Chart Properties, check the box next to "Auto Zoom to Data". If all your points are within the UK, then it should frame your map to a smaller area
    2. Use the same value for all the points so they are the same size. You can do this by creating a beast mode with the formula AVG(1) and dragging it into the Value spot. If you need the dots to be different sizes, check the "Use Log Scale" box under the Scale chart properties instead.


  • Hi Michelle,

    I have changed all values to '1' but the dots are still too large, is there a way to make them much smaller so that we can see the location in more detail? Attached is the current progress. Many thanks