Dundas Dashboard Entering longitude and latitude on maps

Question

How can I insert longitude and latitude coordinates to a map on Dundas Dashboard? I have a table in SQL with City, Province, Longitude, and latitude columns, but when I enter the dataset into the map, it doesn't give me the option to use the tables for x: longitude and y: latitude. The selections for these are greyed out.

Answer 1

Okay. I have figured out how to do this. When you drag your map into the sheet and dropped the data set onto the map and followed the steps. You then click on the map so it opens the properties bar on the right hand side. There you can select symbols. Create new symbol and give it a proper name. Just underneath the tooltip in the Symbols tab is the X(longitude) and Y(latitude) there you can insert the values that is needed to pinpoint the city on the map. Also if you wish to have the name displayed on the map of the city you have entered the location. Click on the map so it is selected. then on the properties menu on the right hand side look for a drop down marked LABELS. Expand the labels and set ENABLE SYMBOL LABELING to true. All the names of the cities will now display on the map.

When you are finished this is what your map should Look like