Issue With Filter in Data Visualization

[prerna_sh]

Hi Community,

I’m working on a Vertical Bar Data visualization for the "Incident table", and all my filters are working fine except when I try to filter incidents where the "reassignment count is 0". As soon as I add that filter, it won’t take the value and no results show up. If I remove it, everything else works perfectly and the data displays without any issues.  Also please refer screenshot.
Any help and suggestion would be appreciated.

Thanks & Regards
Prerna

[mayankkumar]

Hi @prerna_sh,
Which version you're using?

[prerna_sh]

Hi @mayankkumar 

Yokohama

[mayankkumar · Accepted solution]

Hi @prerna_sh,
--------------------------------------------------------------------------------------------------------------------------
Yes you're right, I tried it on PDI same thing happens to me but then did lil workaround and it solved
here are the steps ->
1. Enter the value of reassignment count in filter condition
2. After entering the value click outside, then click on filter overview
3. Hit the Apply button and boom Now when you check it is showing the count you entered
I don't know it's a glitch or something else, you can try this and let me know if that works for you
Here are some screen-shots->
1. 

2.

3.

4.

-------------------------------------------------------------------------------------------------------------------
Please mark my response helpful and accept as solution
Thanks & Regards
Mayank

[prerna_sh]

Hi @mayankkumar 
Thanks for the reply, this really worked out!

[Mark Manders]

The screenshot shows that you are checking on 'reassignment count = ', not on reassignment count = 0. Since it's an integer field, it will always have a value (starting at 0), so searching for no value won't give you any results.

I just checked on my pdi: a data source querying to '=0' does return records.