UK maps - long/lat

Options
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

  • MichelleH
    Options

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

  • louiswatson
    Options

    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

  • MichelleH
    Options

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

  • louiswatson
    Options

    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?

  • MichelleH
    Options

    @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.


  • louiswatson
    Options

    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