In eazybi for jira, we want to create one [measures] that gets the sum of ‘Defect’ type and ‘Test’ type.
However, I would like the ‘Defect’ type to only contain values where the value of the ‘Requester’ field is ‘SW’.
We do not include the ‘Test’ type because it does not have a ‘Requester’ field.
I would like to know a calculation formula that does not affect speed.
ㅡㅡㅡㅡㅡㅡㅡ
-
Create [measures] to represent SW_defect below,
[Measures].[SW_defect]
Sum(
{
[Issue Type].[Defect]
},
(
[Requester].[SW]
)
) -
I tried calling it from other measures. Is this correct?
Sum(
{
[Project].[Etch]
},
(
[Measures].[SW_defect],
[Issue Type].[Test]
)
)
ㅡㅡㅡㅡㅡㅡㅡㅡㅡ
Or, it is configured this way, but it does not work properly…
NonZero(
CASE WHEN
– no selection on Issue dimension
[Issue].CurrentHierarchyMember is [Issue].CurrentHierarchy.DefaultMember
THEN
– iterate through pre-filtered projects list only
Aggregate(
Filter(
– set of issues from relevant projects
Generate(
– pre-filtering selected projects
Filter(
– set of selected projects
DescendantsSet(
[Project].CurrentMember,
[Project].[All ]),
– condition for project relevance
[Measures].[Issues created]>0),
– sets of issues from pre-filtered projects
DescendantsSet(
[Issue].[Project].GetMemberByKey(
[Project].CurrentMember.Key),
[Issue].[Issue])),
– conditions for issues from relevant projects
([Measures].[Issue type] = “Defect”
AND
[Measures].[Requester] = “SW”
)
OR
[Measures].[Issue type] = “Test”
AND
– issue was created in selected period
DateInPeriod(
[Issue].CurrentMember.Get(‘Created at’),
[Time].CurrentHierarchyMember)
),
– the actual measure
[Measures].[Issues created]
)
ELSE
– iterate according to Issue dimension selection - the original expression
Aggregate(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
([Measures].[Issue type] = “Defect”
AND
[Measures].[Requester] = “SW”
)
OR
[Measures].[Issue type] = “Test”
AND
– issue was created in selected period
DateInPeriod(
[Issue].CurrentMember.Get(‘Created at’),
[Time].CurrentHierarchyMember)
), [Measures].[Issues created]
)
END
)
DataCenter version 7.0.1