1 Reply Latest reply: Apr 6, 2017 7:18 AM by Johannes Neppl RSS

    How should I create a map loading geographic data?

    Sebastián Ortiz

      I tried to create a map loading geographic data. A customer base with the latitude and longitude of each client but it does not show the points on the sheet inside my map.

      The format of my file is EXCEL:

           

      CompanyNameCountryCityCityLatitudeCityLongitude
      Company1ArgentinaBuenos Aires-34.60639-58.37383
      Company2ArgentinaRosario-32.945081-60.642199
      Company3ArgentinaCordoba-31.423370-64.177876

       

      The steps I took are the following:

      1- Create a new app called maps

      2- Add data from the data manager

      3- In the data loader I unlocked "Automatically generated section"

      And modified the upload script:

       

      LOAD

          CompanyName,

          Country,

          City,

          CityLatitude,

          CityLongitude,

          GeoMakePoint(CityLatitude,CityLongitude) as CityMapPoint

      FROM [lib://Sense/Mapas.xlsx]

      (ooxml, embedded labels, table is [Reports (10)]);

       

      4- I clicked "Upload Data"

      5- Create a new sheet and drag a map

      6- I added the dimension "City"

       

      But it did not show me the points.

       

      What is the problem?

       

      Thanks for your helps!