[IGN-2200]Replace values displayed as "null" in the perspective table

[witman]

If those columns are supposed to be numbers, a script transform like this to set the correct column types should work:

[BUG] Perspective Table number format breaks if first row has null value

Hopefully the underlying Perspective Table implementation will handle this in the future for columns with specified types. For now, this script transform does the trick: from java.lang import Float from com.inductiveautomation.ignition.common.util import DatasetBuilder if value is None: return value else: # Build new dataset with specified column types. colNames = ["Month 1", "Month 2", "Month 3"] colTypes = [Float, Float, Float] b = DatasetBuilder.newBuilder().colNames(colNames…

If they are strings, you could do a script transform that replaces the null with "".