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 or Signup to post a comment