Hi Team, any pointers on how to filter a table report like this one attached, to only show "Business" values where the overall (aggregated) completion % is above a certain threshold, while maintaining the breakdown of user, job title and individual content? I've tried using the metric filter, but it ends up looking at each row individually, and not at the aggregated Business level. The ultimate issue I have is that I need this to dynamically show only the businesses with a completion rate >80% and tie this report to a headline one, so by clicking the headline I can see this breakdown report.

Hello Raffaella, I can see you're trying to filter at an aggregated level (Business) while maintaining the detailed breakdown. Here are some approaches you can take when implementing this: Using Ranking Filters with WITHIN You can use a ranking filter with the WITHIN clause to filter at the Business level. Create a metric like: `SELECT Total Completion % WHERE TOP(100%) OF (Total Completion %) WITHIN (Business)`Then add a condition to only show values above 80%. The

WITHIN (Business)

statement locks the granularity at the Business level, so the filter evaluates completion % for each Business unit as a whole, not individual rows. Alternative: Nested Metric Approach You could create a helper metric that calculates completion at the Business level: `SELECT Total Completion % WHERE (SELECT Total Completion % BY Business) > 80`This evaluates the condition at the Business aggregation level before applying it to the detailed rows. In regrads to connecting to Headline Report For your drill-down requirement from a headline to this breakdown report, you can set up a drill-in path. In the headline report configuration: 1. Go to the Drilling tab 2. Under "When I click on", select your completion metric 3. Under "Show me", select the Business attribute to break down by This will maintain the same metric while filtering for the selected value and showing the breakdown by Business, Full name, and Job title. The knowledge sources don't explicitly detail filtering aggregated groups while maintaining detail rows in tables, so you may need to experiment with these MAQL approaches or consult GoodData support for your specific use case. Answer based on the following sources: *Extended TOP and BOTTOM Ranks*help.gooddata.com/classic *Drilling In*help.gooddata.com/classic

Hi Joseph. Thanks for the suggestions, I didn't manage to have these metrics work with the detailed table report unfortunately, as they kept filtering the individual user / content rows, but was able to set up the drill down eventually. Generally speaking is there a way to filter visualisations by a specific metric without having to explicitly include that metric in the visualization? I wasn't able to find a way to do that. But checking just in case

Hello Raffaella, no, you cannot filter a visualization by a metric that is not explicitly included in the visualization. However, the recommended workaround is to create a new metric that embeds the filtering logic using MAQL. As suggested in a community discussion: `SELECT {metric/your_display_metric} WHERE TOP(10) OF ({metric/your_filter_metric})`This allows you to display one metric while filtering based on another metric's values, without needing to show the filter metric in the visualization.