Data missing from map chart

Data missing from map chart

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:

Sum([Class Sales])

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))

Doc: Conversion Functions > SN()

• https://docs.tibco.com/pub/spotfire_server/7.11.0/doc/html/en-US/TIB_sfire-bauthor-consumer_usersguide/GUID-BA99A15A-E57B-4B6F-B475-263F561D2697.html