Map with bubbles - Location names instead of Lat/Long?

by mroberts » Thu Jul 13, 2017 2:49 pm

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. :)
Posts: 2
Joined: Thu Jul 13, 2017 2:44 pm

by Nikita Kurguzov » Fri Jul 14, 2017 1:51 pm

Unfortunately, Lat/Long are both required. Easiest way to do what you want would be to add Lat/Long manually to the list of States. Then, in your list where you have a lookup for the states, go to list settings, select your lookup column and select additional fields of Lat/Long:
Additional Fields for Lookup.png
Additional Fields for Lookup.png (5.08 KiB) Viewed 68 times

Then go to Dashboard Designer and build the Map.

User avatar
Nikita Kurguzov
Posts: 24
Joined: Fri Jul 14, 2017 1:35 pm

Return to Dashboard Designer for SharePoint 2013