Insight - Returning "Blank" values after trying to Filter
I'm having an issue where after filter a particular field to "Not Null", I'm still getting fields with 'blank values' in the report.
Hi @Nicholas McKeta ,
Maybe you can turn them to zero then display greater than zero. Check this out
Thanks! I'll have to try that!
Alexa Kalapaca-Oracle Posts: 177 Employee
@Nicholas McKeta Some fields aren't actually NULL in the database. For example, contact custom fields don't store NULL values. You would have to use a query that looks for a "space" value only. Hopefully that post above helped though.
--- excerpt from MCX 2019 slides
Custom fields for Accounts, Contacts, and Campaigns do no contain NULL values in Insight. Depending on the data type, “NULL” values are:
- Text: space
- DateTime: 1900-01-01
- Numeric: 0