Hi Team, why I can't add metric filter to the view that Rev_LY !=0

Thinking completed In GoodData Analytical Designer, ranking filters (Top/Bottom values) cannot be combined with metric value filters in the same visualization [Use Ranking Filter]. As shown in the tooltip from your image ("To enable, remove the top/bottom values filter."), the presence of the Bottom 5 filter disables the metric value filter for

Rev LY (M5)

. Alternative Solutions If you need to rank while excluding zero/null metric values, you can use MAQL: 1. Incorporate the condition into your metric definition: You can update or create a custom MAQL metric using

WHERE TOP/BOTTOM IN

and include the condition directly in the ranking calculation [WHERE TOP or BOTTOM IN; Slack forum]:SELECT {metric/your_metric} WHERE BOTTOM(5) IN ( SELECT {metric/vs_LY_percent} BY {attribute/venue}, ALL OTHER WHERE {metric/Rev_LY} <> 0 ) 2. Filter via MAQL at the metric level without visual filters: You can define the metric itself to only evaluate where

Rev_LY <> 0

before ranking or aggregating. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.