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.