Spotfire Ideas Portal
Add a new idea Subscribe
Status Implemented
Product Spotfire
Categories Visualization
Created by Guest
Created on Feb 6, 2016

RELATED IDEAS

Display empty values in cross table as blanks or 0s instead of '---'

There should be an option to choose which string to display in the place of empty cells in a cross table instead of "---" which is currently displayed. E.g. " ", "0" or "N/A" is sometimes or better option. 

Implemented in 7.7
  • Attach files
  • Guest
    Oct 31, 2016

    This has been implemented in Spotfire 7.7:

    https://docs.tibco.com/pub/spotfire/general/WhatsNew77/GUID-DD5D9CBF-7C9B-4551-B16A-F2FF0D137B88.html

    Reply
  • Guest
    Jul 19, 2016

    Also to replace (empty) with something else.  I think if you could do this in the document options and set it up as a default ie. use no data available instead of (empty) OR over-ride the default document option in the individual value calculation/expression (even as an input form for the null value on the custom expression window would be great! - then it's a simple coalesce for spotfire ie. coalesce(calculated value, specified value, document option, spotfire default).

    Reply
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved