Skip to Main Content
Spotfire Ideas Portal
Status Implemented
Product Spotfire
Categories Visualization
Created by Guest
Created on Feb 6, 2016

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

  • Guest
    Reply
    |
    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).