10 Replies Latest reply on Oct 21, 2018 1:06 PM by Natalie Phillips

    Spacial File, CSV file, and dual-axis mapping

    Natalie Phillips

      Hi Everyone,

       

      I am working on mapping crime data by neighborhoods for the city of New Orleans. So far, I have been able to join the shapefile with the CSV file in tableau using 0 = 1 full outer join (instructions provided here Dual Axis Mapping - Many Ways ). I am now running into the issue of how to be able to count the crimes by neighborhood location- so far the points show up on top of the map from lat/long inputs, but I am not able to count crimes by location. Does anyone know how I may get either excel or tableau to recognize which lat/long is in which neighborhood?

       

      I have attached the workbook for just the map if anyone is able to help me out! (map and excel workbook is too big to upload)

       

      Thanks,

       

      Natalie