Issue With Filter in Data Visualization

prerna_sh · 4 weeks ago

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 · 4 weeks ago

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

View solution in original post

JackieZhang · 4 weeks ago

you need to check if there is data for reassignment account =0. It is working fine in my PDI

prerna_sh · 4 weeks ago

Hi @JackieZhang

Yes, we have data if reassignment count = 0, and it's not even taking value as "0" or any other number

Bhuvan · 4 weeks ago

@prerna_sh

You can filter the data source for this,

Before Filter,

After filter,

If you are trying to group 'Reassignment Count' field in dashboard, try creating 'Bucket Groups'.

Thanks,

Bhuvan

prerna_sh · 4 weeks ago

Hi @Bhuvan
My condition is "reassignment count =0", but it is not even taking any numeric value I tried changing the value, you can view in above attached screenshot. And for "bucket group" I'm not using indicator, if I'm getting wrong can you please guide me on "bucket group".