1 Reply Latest reply on Oct 22, 2018 2:56 PM by Don Wise

    Cleaning up my data so as to create a Map Viz with my data set

    Adeleke adefabi

      I have this unstructured data set that has location coordinates(latitude and longitude) in the same column, with some other geographical data that has to do with the location ordinates.I converted the location coordinate to country/region so that tableau can recognize it as map coordinate and also a column in the data set UNSD grouping to region. But with all this cleaning and manipulation, I wasn't able to create a map viz with the data.

       

      Want to create a map viz, that shows total number of death and missing by region.

       

      Attached is the workbook that contains the data set.

        • 1. Re: Cleaning up my data so as to create a Map Viz with my data set
          Don Wise

          Hello Adeleke,

          Please see attached (2018.2) workbook and below screenshots for changes made. SPLIT function works well with your problem.  If this answers your question please mark this response as correct. Thx, Don

          Screen Shot 2018-10-22 at 2.45.48 PM.png

          After SPLIT function, set from string to Number (Decimal) for each:

          Screen Shot 2018-10-22 at 2.46.09 PM.png

          Set to appropriate geographic role:

          Screen Shot 2018-10-22 at 2.46.17 PM.png

          Set to their geographic roles:

          Screen Shot 2018-10-22 at 2.46.31 PM.png

          Convert from measure to dimension:

          Screen Shot 2018-10-22 at 2.46.47 PM.png

          Screen Shot 2018-10-22 at 2.46.54 PM.png

          Rename to Lat or Lon as appropriate.

          Screen Shot 2018-10-22 at 2.47.24 PM.png

          When Lat/Lon are placed on row/column you'll see only 1 point. See following to disaggregate the data:

          Screen Shot 2018-10-22 at 2.47.56 PM.png

          Click Analysis and uncheck this box.

          Screen Shot 2018-10-22 at 2.48.01 PM.png

          You'll now be able to drag dimensions to use size/color and fill out your map:

          Screen Shot 2018-10-22 at 2.52.39 PM.png