3 Replies Latest reply on Mar 10, 2018 3:47 AM by andy ZZZ

    311 Calls per NYC borough and Zip Code. Now need to plot median income per Zip Code.

    andy ZZZ

      Currently, I can see that, for example, the Bronx is a borough with more calls to 311 than Staten Island. For our Analytics class, my teammates and I would like to be able to plot the median income per Zip Code so that the viewer of the data is able to see whether or not there is a correlation between the number of calls to 311 and the median income.

       

      We have spent many hours trying to figure out how to get the median income onto our plot of 311 calls per borough and Zip Code; however, we have been unable to systhesize these two data sets.

       

      We would sincerely appreciate it if you could give us any guidence. Thank you so much!!

       

      Dataset 1: 311 Calls, includes Zip Code and the type of call

      Screen Shot 2018-03-05 at 4.30.51 PM.png

      Screen Shot 2018-03-05 at 4.30.59 PM.png

       

      Data 2: Excel file with NYC zip codes and median income. Some of these Zip Codes may not residents making calls to 311, as this file was created independently of the above file.

      Screen Shot 2018-03-05 at 4.11.57 PM.png

       

      The Issue -- Median income doesn't appear properly!

       

      Screen Shot 2018-03-05 at 4.45.06 PM.png

      Screen Shot 2018-03-05 at 4.42.19 PM.png

       

      *Please note that the Tableau packaged workbook is very large and it is desktop version 10.5.