hello
I have integrated my Xray data to Eazybi
there are dimension specific for bugs such as status / priority
can I also add another custom field as a defect dimension ? and if yes then what are the steps ?
solved this one as follow
- add the cusom field to Eazybi
- add a calculated dimension field for bugs as follow
(issue.fields.issuetype &&
issue.fields.issuetype.name == "Bug") {
return issue.fields.customfield_10043;
}
use a measure for unique count og bugs per test case
NonZero(Count(
Filter(
--iterate through defects related to the test and execution
Descendants([Xray Defect].CurrentHierarchyMember, [Xray Defect].[Defect]),
[Measures].[Xray Tests defect count] > 0
)
))
and use a measure of cound defects per custome field SB (sevirity bugs)
Sum(
--set of defects
Filter(
Descendants([Xray Defect].CurrentHierarchyMember, [Xray Defect].[Defect]),
--for each defect gets its property with Geschäftsprozess and checks if its matches the selected value on row
CoalesceEmpty(
[Xray Defect].CurrentHierarchyMember.get('bs'),"(none)"
) = [bs].CurrentHierarchyMember.Name
),
--defect count ignoring which Geschäftsprozess is assigned to test execution
([Measures].[Unique defect count],
[bs].DefaultMember)
)
1 Like
Thank yuo @jira_jira for the update with the solution. Yuo figure it out and solved elegantly =)
I just want to add some useful links to the documentation for future readers:
- Documentation on how to make Account specific calculated fields
- Training video Advanced MDX: Recipe to Change Report Context
Best,
Zane / suport@eazyBI.com