Filter out null values

Litmon

started a topic almost 3 years ago

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?

J

Jouni Hyötylä
said almost 3 years ago

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
L

Litmon
said almost 3 years ago

What I'm saying is that the filters don't help. The filter does not provide the option to filter out null values and it doesn't provide the option to do greater than (just contains, does not contain, matches regex).
J

Jouni Hyötylä
said almost 3 years ago

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
N

Nelson Spencer
said over 2 years ago

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.
J

Jouni Hyötylä
said over 2 years ago

Hi Nelson,

could you also send us screenshots of your sidebar showing all the details in your query. Thanks!

Best regards,

-Supermetrics Team
I

Insights Optimisation
said 11 months ago

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.

Didn't find what you were looking for?

Start a new topic

Filter out null values

Topics in this forum

Didn't find what you were looking for?