If you have country values in your dataset, these values need to be ‘mapped’ to countries in order to display the results on a world map in the map view. You can also map cities (or sites) within a country. When zoomed in on a country the results per city are displayed on a map.
Countries and cities
Countries
If the country values are standard country names in English, the values are automatically mapped. Other (non-standard) country values need to be assigned manually. There is a simple interface to do this. In the characteristics tab, you can find the link (Mapping) after the characteristic Country. This interface link is also available if you edit the characteristic Country.
The mapping country overview contains a list of already assigned country values and to which country they are assigned. At the bottom you will find the message ‘There are xx unmapped country value(s)’. This is the number of unique values in the country column of your data that have not been assigned yet.
If you click the button ‘+ add country’ you will see a window to assign these values.
Check the value you want to select from the right column. From the top left drop down menu select the country you want to assign this value to. The ‘display name’ is the name that will be shown in the dashboard. The interface automatically suggests the default country name but you can edit this value if you want to. Press the button ‘OK’ if you are finished. You can repeat this process to assign all unique country values in your dataset.
Cities or sites
If there are city or site values available in the dataset, you can plot these on a map. When zoomed in on a country in the map view, you can see the scores per location.
When setting up a dashboard, you defined if you either wanted to plot city values or site values on the map. To plot the different locations on the map to the tab characteristics double click on city or site to open the edit mode. In this screen press the button ‘Define mapping’ to open the mapping overview. This overview contains the already assigned city/site values. Click the button ‘+add city’ at the bottom to start mapping.
You get a list with all unique values that have not been mapped yet. Choose a value on the right and on the left enter the display name and the coordinates on the map. If you press OK, this particular value has been mapped to that location on the world map.
With the button ‘add to group’ you can group multiple values. All these values will be considered as one location and in the calculations of all these grouped values will be aggregated to one score.
If locations are very close together, you can also select multiple city/site values on the right to be ‘clustered’ into one spot. The scores are individually calculated but on the map a symbol is shown that indicates how many values are clustered. When hovering your mouse over this symbol the scores for the individual locations are shown. Underneath an example of how the scores for different locations are plotted on the map.
