Countries and cities

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.


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.

Characteristics overview with mappping link
Click on the link (Mapping) in the characteristics page to start

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.

Country mapping overview
Country mapping overview

If you click the button ‘+ add country’ you will see a window to assign these values.

Adding a country
Assigning a country value to a country

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.

Adding city values
Interface to group values and define coordinates with cities or sites

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.

Display city scores
Example of how city/site scores are displayed. The values Liverpool and Manchester are 'clustered', so they do not overlap in the map.