Filter with empty string

Ask the Community
1

I have set of text-type dimensions where value is sometimes an empty string and sometimes null.
Is there a way to filter the report to show only rows where value matches to an empty string? Or is there workaround to use a wildcard as a filter?

1 Like
2

Hi @Engineer,

We understand it is quite annoying when you can’t filter on empty strings and null values as we don’t support it right now. However, you can create a custom field in the data model to define the empty string as a unique character (In this case, you can consider using CASE WHEN). Btw, we will add this to our backlog to make it more convenient in the future.

Cheers

3

filtering for null values is available now in the conditions drop down, are empty strings still not supported at this point?

thanks!