Null, NaN, and No Name values can appear in reports if:
- an empty property string is sent
- an empty numeric property value is sent
- a property isn't set in an event
Insights reports will return a null value when a property is not set in an event or when an empty string is sent.
Segmentation reports will return an "undefined" value when a property is not set, and a null value when an empty string is returned.
Funnel reports will return a "NaN" (Not a Number) value when a null numerical property is returned when segmenting a Funnel.
Remove Null or NaN from reports
Null/NaN values can be removed from reporting by typecasting the property to a boolean, and setting it equal to True.
Related Topic: What does an undefined property mean?