I have this filtering problem where it affect my widgets on the dahsboard as well. I noticed that my widget (gauges) couldn't display the value when filtered.
When I check with my WebMap, I noticed that I couldn't filter the table using "Value", but managed to do it when selecting "Unique" instead. I suspected this lead to the problems of the widgets returning zero values.
I need help to understand what caused this problem and how can I rectify it.