Filtering on NULL and empty values is a special case, since both display the same way in tables and charts.Filtering on null, blank, or empty values can be tricky if your data contains more than one of these. Use this method to see what’s really going on with these values and get the filtering behavior you want. Null, blank, and empty values are actual values in your data — they are not placeholders for query errors, with one exception: invalid values, such as dividing by 0, display as NULL.
-- is Invoca’s placeholder for a query error, which may include issues fetching the data query, the query returning no data, or incomplete Interaction Details.
How NULL and blank values are displayed
When you view a table or chart, you may see values shown as{blank}. These can be one of two types: NULL values, which are missing or invalid (for example, from dividing by 0 — Invoca also shows NULL for n/a in your data), or blank/empty values, like an empty string of text or a string of only whitespace.
Both types display as {blank}, but if you filter on {blank}, the filter applies only to NULL values.
NoteInvoca automatically adds the
{Null} value to the filter options for every column, even if the column has no {Null} values. Contact Invoca Support if you don’t want this.Show NULL and blank values differently
To differentiate between NULL and blank values, add a formula to make them appear differently in charts and tables:Allow filtering on both NULL and blank values
To keep the same display format for NULL and blank values, but filter on both using{blank}, use a formula like:
Filtering on your formula
After creating the formula, filter on it in the search bar by typing{blank} or {null}. Or, left-click a {blank} or {null} value in your search result table, then right-click and select Show only “value” (where value is the one you clicked).