Product: TIBCO Spotfire®
Cross Table visualization does not fill in custom text for missing data based on "Display cells with no data as" setting
In Cross Table visualization Properties > Appearance, there is the option to display custom text when cells have no data by using the "Display cells with no data as" > "Custom text" setting. It may seem that some of the empty cells in the Cross Table are not replaced with that custom text as expected.
This behavior is because the Cross Table differentiates between null/empty values and when there are no rows in the data set which corresponds to the cell. The text specified in “Display cells with no data as” is used only when there are no rows in the data set that corresponds to the cell i.e if the vertical axes value has no corresponding horizontal axes value in the data set. Note: Null/Empty value are formatted as an empty string.
For example, assume a data table like:
ID NAME Phone 1 AAA 123456 2 BBB
When creating a Cross Table based on the above data set with [ID] on the vertical axis and [Name] on the horizontal axis, and with a custom text defined in "Display cells with no data as", the result would be:
ID AAA BBB 1 123456 MyCustomText 2 MyCustomText
Explanation:
- The original data table has a combination of ID=2 and NAME=BBB, and that corresponding cell contains a null/empty value. In this case, the corresponding cell in the Cross Table is not replaced with custom text.
- The original data table does not have a combination of ID=1 and NAME=BBB. In this case, the corresponding cell in the Cross Table is replaced with custom text defined in "Display cells with no data as"
- The original data table does not have a combination of ID=2 and NAME=AAA. In this case, the corresponding cell in the Cross Table is replaced with custom text defined in "Display cells with no data as"