Start a new topic

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?


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

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

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

Login or Signup to post a comment