Filter issue

Hello Team,

I am facing an issue with filters, as I am filtering the visual for one metric, the metric that I am filtering ideally should be removed from the visual but in my case it is showing 0. Attaching the Screenshot for reference. We have actually used Union in the query, and it is reflecting 0 for all null values.

Is the value that you want to filter out always going to be 0? If so you can simply add a filter to the table of SHOP_ORDER != 0


I can see that the filter is using a ‘SNOP_ORDER’ (in capital letters) as the filtered value, while the pivot table is showing the metrics in lower case (“snop_orders”). They need to match if it is a filter.

Let us know if this solves the issue.

1 Like