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!!