I have a SharePoint list that people choose one or more states from a list for each item (what is the project location, may have multiple locations). What I’d like is a map with bubbles for the count of projects in that state. But the dashboard maker requires Lat/Longs… If I did a lookup or calculated column in the list, it wouldn’t calculate each of the locations into Lat/Longs, so what can I do?
I’m not a programmer, so please be gentle.