Loading

Showing Maps with Missing Data

Дата публикации: Feb 23, 2025
Задача
How to show data that isn't present in a data set on a map.
In the following example, the Countries Belgium and Germany disappear from the view because there is no line with data of these Countries in the data set.
 
CountryData
Netherlands1
France1
User-added image
Действия
By design, missing data will disappear from the view. In this example, workaround this design by adding Countries with the value 0 in a new Sheet in Excel, and then joining the data with a master table of Countries. The data and the workbook can be downloaded from this article (in the top right corner).
  1. In this example, ensure your data source contains a sheet all required countries and Zero (0) values assigned to them
  2. For this example, we're adding the data source again a new data source
  3. Join both sheets from the data pane using the Country field
  4. Build the map view, add the Value from Sheet 2 to Color
  5. Drag the Country field from Sheet 1 to Details
To view the above steps in action, see the video below.
Note: the video has no sound. To view the video in higher quality, click the YouTube icon below to watch it on YouTube directly.
Дополнительные ресурсы
The same result can be achieved with only one sheet of the data, which will need to be related it to itself.
Номер статьи базы знаний

001456985

Вложения

countries data.xlsx

10 KB

Countries missing.twbx

39 KB

 
Загрузка
Salesforce Help | Article