Grouping of components from multi projects

Questions & Answers
2

Hi,

Project dimension groups components under each project, and, currently, this is the only way how components are grouped in Projects dimension.

There are two ways how to get the same name components displayed as one row in the report table.

Option 1. If you have a few components and this list is quite static.

Then you may want to create calculated members in the Project dimension for each component, where you aggregate all the same name components. Example of the formula for aggregating components “Web” from all projects.

Aggregate(Filter(
  [Project].[Component].Members, 
  [Project].CurrentMember.name MATCHES 'Web'
))

The calculation is case sensitive!
Then use all those calculated members in the report rows.

Option 2. If you have a lot of components and they could be added rapidly

Then the best would be creating a new Components dimension calculated during data import: for that, use JavaScript calculated custom field.

First, define the custom field settings together with the JavaScript code in eazyBI advanced settings:

[jira.customfield_eazybicomponent]
name = "Component"
data_type = "string"
multiple_values = true
split_by = ","
dimension = true
javascript_code = '''
  issue.fields.customfield_eazybicomponent = issue.fields.components;
'''

Then, in the eazyBI import options custom field list, find the field “Components” and select it to be imported as a dimension. Perform data import.

Finally, in the Analyze tab, find this new Components dimension (under custom fields dimensions) and use in the report rows as any other dimension.

Ilze, support@eazybi.com

3 Likes