Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on May 25, 2017

Display Null/Empty as something else (ie, 0) in Graphical Table

We have a user who has a graphical table, however, within the report they see that graphic tables have "---" to represent missing rows. They would like to pre-fill it with "0" or "N/A" if possible. Is it?

  • Attach files
  • Guest
    Reply
    |
    Jun 16, 2017

    I had to revisit the issue, looks like the user was on 6.0, not sure what their logic is.

    In attached image, for 7.7, you can see that Sparkline is using "...", whereas SUM() is "(Empty)".  I believe in older versions, sum of null data is the --- record.

    The "(Empty)" display is an improvement, but the users would actually be looking to substitute this with their own logical displays, such as 0 or N/A to indicate no such values.

  • Admin
    Niklas Amberntsson
    Reply
    |
    Jun 16, 2017

    Harold, can you please show with an image what you are referring to?