Issue with filter not returning any values

Q&A
,
1

Hi,

I have a table where one of the fields is a flag set to either 0 or 1.
When I apply the filter to return the 0 values i get the data filtered correctly but when i set the filter to return the 1 values i get no data in the visualization.
I have bot 0 and 1 in the dataset as per following screen shots.

Filter set to return everything:

image
image1182×1146 64.2 KB

Filter set to return 0 only:

image
image1195×1207 70.3 KB

Filter set to return 1 only:(NO DATA IS RETURNED)

image
image1212×1337 41.5 KB

I’m I missing something or is a bug in the filter?

Thank you in advance for the help.

Best,

Dom

2

Hi @Dom,

I have tried with a test dataset and it works fine for me

image
image1048×591 35.3 KB

image
image1072×604 31.4 KB

image
image1044×601 31.9 KB

I am not sure what can be the issue but might be related to your dataset. I see that because of the multiple values it looks like you have this setup as a string so this might be related.

Can you try with a test dataset with only 0s and 1s and see if you can replicate this?