Null, Nan, and No Name Values

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.

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?