EazyBi, how to display a subset of components in a pie chart diagram?

[Antoine _Klee Group_]

Hello, I am an EazyBI newbie.

I want to display a custom measure which would correspond to only certain values of components. For example, in this diagram, I only want the three components circled red to be displayed. 

I tried doing a custom member with the follwing formula

[Project].[component_impactTechnique] = 

Aggregate(
Filter(
[Project].[Component].Members,
[Project].[Component].CurrentMember.Name MATCHES "Webservice"
OR
[Project].[Component].CurrentMember.Name MATCHES "BDD"
OR
[Project].[Component].CurrentMember.Name MATCHES "Responsive"
)
)

But this is what's displayed

I thought of removing the "Agregate" function to make a list of values but obivously as the filter returns a set, this did not work.

Any idea?

[eazyBI Support]

Hi @Antoine _Klee Group_ 

You can add the "Project" dimension both in Rows and Pages. In Rows select the "Component"  level and in Pages your aggregate member to filter the components you want to see in the report.

Also, if you are an eazyBI newbie then you can check those training videos: https://docs.eazybi.com/eazybi/learn-more/training-videos

Kind regards,
Gerda // support@eazyBI.com

[Antoine _Klee Group_]

Thanks it does seem to work (almost) fine.

The components are filtered but some appear to be duplicates. Is there a way to unify all the "BDD" components (which are used across several projects) into a single one.

[eazyBI Support]

@Antoine _Klee Group_ 
For that use case, there is an option that you can create a separate aggregate member per each of those components and then select them separately in the report. 

Or you can import one "Component" dimension that would consolidate all the components from all the projects and then filter the needed ones. See how to create one component field in eazyBI using a JavaScript calculated field: 
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Component

Kind regards,
Gerda // support@eazyBI.com