Adding Data to a Map

Data is added to a Map chart in the same way as it’s added to many of the other chart types, please refer to this section for more information. The only difference is that Map chart types require coordinates in order to create the chart. These must exist in your data in the form of longitude and latitude. Unless you have latitude and longitude stored in your database already, you will need to create a table or view that contains this information that you can then join to your dataset ; this might be at a very granular level such as postcode or it might be at a higher level such as mapping ‘Northern Sales Region’ to the latitude and longitude for somewhere central to your sales region of that name (Wikipedia entries on most cities will provide their Latitude/ Longitude).

A bubble is displayed on the chart for each of the coordinates in your data. The size of the bubble is determined by a number which is added to the data objects in the form of a Measure.

Open

Multi-Dimensional Map Charts

Multi-dimensional maps, available in the January 2022 release, can be created by adding a legend to your map. To do this, add the relevant dimension to the legend field on the Data tab.

Open

Similar to multi-dimensional charts, the legend will appear on the side of the map and colours of the data points changed accordingly.

Users will also be able to add sorting, filtering, colours and label formatting to the Legend and change the position of the Legend (although unlike other chart types only 4 positions will be available).

Information from the Legend will also be displayed in tooltips.