1 Reply Latest reply on Aug 21, 2018 9:53 AM by Kent Marten

    Show count of values which fall in an area based on coordinates

    Vaibhav Singh

      I have a workbook (attached) on which I have wards mapped & plotted in tableau. I have another excel file (also attached) which contains street lights data & coordinates of each light.

       

      Now I want a final sheet where my wards data is plotted with the count of street lights that fall in a ward (based on coordinates info). Forex:- If ward 1 has a particular area, then all the street lights whose coordinates fall in that ward, the sum of that should be displayed in the final sheet.

       

      Tried everything please HELP!!