Collection of data in different categories

[1115]

Hi
I am trying to measure the total percentage by aggregating data from different categories like this.

Project	A type issue	All fix version	a component	All resolution	34	4%
		All fix version	b component	All resolution	546	6%
		All fix version	c component	All resolution	6	6%
		All fix version	d component	All resolution	74	7%
	B type issue	e fix version	All component	All resolution	76	2%
	B type issue	f fix version	All component	All resolution	99	1%

How can I collect data with different upper categories?
or how can I put several conditions into one filter to make data like the table?

[martins.vanags]

Hi @1115

First, you could use advanced settings: to define new pre-calculated field “Component” and import it as a separate dimension.
See steps here:

Grouping of components from multi projects

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 c…

Then you could use the"issue type", “Fix version”, new “Component”.
Next, create a new calculated measure that would use some validation rules and show results only for certain rows where the validation rules are met.
See this example for two story types in the report

CASE WHEN
[Issue Type].CurrentMember is [Issue Type].[Story]
THEN
  CASE WHEN
  [Fix Version].CurrentMember.name = "All fix versions (expanded)"
  AND
  [Component].CurrentMember.level.name = "Component"
  THEN
  val([Measures].[Issues created])
  END
WHEN
[Issue Type].CurrentMember is [Issue Type].[Bug]
THEN
  CASE WHEN
  [Fix Version].CurrentMember.level.name = "Version"
  AND
  [Component].CurrentMember is [Component].DefaultMember
  THEN
  val([Measures].[Issues created])
  END
END

Later, filter the report by new calculated measure (new measure > 0)
https://docs.eazybi.com/display/EAZYBI/Create+reports#Createreports-Orderandfilterrowsbymeasurevalues

Finally, create a separate calculated measure with % format to calculate the % from total.

    [Measures].[Issues created]/
(
[Measures].[Issues created],
[Issue Type].DefaultMember,
[Fix Version].DefaultMember,
[Component].DefaultMember
)

See the attached images

Martins / eazyBI support

[1115]

Thanks for your help.
I solved it by attaching all the data as a single String and filtering them using “javascript custom field” like “(fixversion:F),(component:test),(issuetype:Bug),…”