Filter out null values
There doesn't seem to be an option to filter out null values. Is there a specially character I can use to filter for a field that has a value in it?
There doesn't seem to be an option to filter out null values. Is there a specially character I can use to filter for a field that has a value in it?
Hi Litmon,
you have to use filters to accomplish this. Choose the filtered value, select the filter option (for example "greater than") and set up the reference number.
Best regards,
Jouni Hyötylä
supermetrics.com
Twitter: @Supermetrics
Support forum: support.supermetrics.com
Hi Litmon,
can you send us a screenshot of your query in the sidebar and we'll try to figure out a way for you to accomplish this.
Best regards,
Jouni Hyötylä
supermetrics.com
Twitter: @Supermetrics
Support forum: support.supermetrics.com
Trying to do a similar thing here - filter out Null or blank values. It's for a text field so I can't use greater than.
Hi Nelson,
could you also send us screenshots of your sidebar showing all the details in your query. Thanks!
Best regards,
-Supermetrics Team
Hello Community,
I was looking for a solution to this exact question, and noticed this hasn't been addressed.
The solution that I have implemented is to use a regex match of '.'
This is a wildcard regex for "any character", so the text field cannot be empty.
Hi,
I have a similar problem. I filtered out the Null but when I blend the data they appear again and no I can't filter it our because other rows would be also exluded than.