Data missing from map chart
Article ID: KB0082515
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
After configuring a map chart with a Marker layer, you may notice that some of the data does not appear on map chart as expected.
This can happen when the columns used in the "Size by" expression of the Marker layer have null values (and thus the evaluated result of the expression is also null). Those rows with null values will not appear. For example, see the attached sample dxp file "Sales and Marketing_KB-SN().dxp". In the "SalesAndMarketing" data table, column "Class Sales" contains empty values. The expression for "Size by" axis is: 
This can happen when the columns used in the "Size by" expression of the Marker layer have null values (and thus the evaluated result of the expression is also null). Those rows with null values will not appear. For example, see the attached sample dxp file "Sales and Marketing_KB-SN().dxp". In the "SalesAndMarketing" data table, column "Class Sales" contains empty values. The expression for "Size by" axis is:
Sum([Class Sales])
Issue/Introduction
This article explains one reason why some data may not appear on your map chart
Resolution
To resolve the issue, you can replace null values using the SN() function so that all rows will be evaluated (and if the row was null, it will now be sized as if it were 0). Here is the expression to use on the "Size by" axis in the Map Chart: 
Sum(SN([Class Sales],0))
Additional Information
Attachments
Feedback
Yes
No
Powered by
