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!

4

@thienpham - I noticed this is still not supported. Furthermore, it looks like it should be supported because I can select an empty string, but then Holistics reverts back to treating it as “Any Value”

image
image710×438 22.6 KB

5

Hi @SterlingParamoreMSE,
Yes this is still not ‘officially’ supported.
However, if the suggestion list has empty string value, you can still select it (this should be similar to your case).
Regarding the issue that Holistics reverts back to treating empty string as “Any Value”, it looks like a bug. We will investigate and fix it ASAP. I will keep you updated!