How to filter out some components showing in dashboards if multiple components describe each issue?

Question

I am working on a project where each issue is listed with several components (e.g. Issue is related to the Core component, the Documentation component, and the Feature component). When I create a dashboard with a report like two dimensional filter statistics, I want the report to only show the total issues for 2 of the 3 components. However, I see no way to do this with a filter since when I use the "not in" syntax it eliminates every component that has the component I dont want to see even if it also has the components I want to see. How can I only show certain components in my reports despite components being multilisted by issue?

E.g.

Issue 1 - Components: Core

Issue 2 - Components: Core, Documentation

Issue 3 - Components: Documentation, Feature

Issue 4 - Components: Core, Feature

With this set, even if I want a report that only shows issues by Core and Documentation components, I keep seeing the Feature component in my reports. If I use the filter with the "not in" syntax, then issues 3 and 4 from the example are filtered out, even when they are still relevant for the Core and Documentation components.

Theresa Tanner · Answer

@Ciprian thank you for your help! I will check that out.

Ciprian_4pfbk8 · Answer

Hi @Theresa Tanner yes I managed to find a solution using a really useful gadget, that let you play around with pretty much any field in any possible way. See my reply for Labels here, but works exactly the same for Components

Theresa Tanner · Answer

@Ciprian Did you ever get a response to this? I am having the same issue and need to run a report with only one of the 7 components showing. Any help would be appreciated!