Filter out blank-but-not-null values

Frequently, I find that I get data through Supermetrics that appears to be blank but that is not treated as a "null" value by Data Studio.

Since Data Studio doesn't treat it as "null", I can't filter it about by using an "IS NULL" statement. And since the data is blank, I also can't filter it out by using a "CONTAINS".

Has anyone figured out a way to filter out these values in Data Studio?

  • Update - figured it out.

    Exclude > REGEXP_MATCH ('[^\S]*') to exclude every result that does not start with a non-space character.

Login to post a comment