I need to develop a cumaltive bar chart over time (weekly) for the number of issues assigned to a specific [Fix Version] within a week.
Using:
Rows: Time Dimension, All hierarchy level members, weekly, week
Columns (user defined):
(1) Measures.[Count in Version]:
Aggregate({
[Fix Version].CurrentMember }
)
(2) Measures.[Cumulative Bugs in Release]:
CoalesceEmpty(NonZero(Sum(
-- time periods from start of time to current period
{ Generate(StripCalculatedMembers(
Ascendants([Time].CurrentHierarchyMember)),
IIF([Time].CurrentHierarchyMember IS
[Time].CurrentHierarchyMember.FirstSibling, {},
{ [Time].CurrentHierarchyMember.FirstSibling:
[Time].CurrentHierarchyMember.PrevMember } ) ),
[Time].CurrentHierarchyMember
},
-- expression to aggregate
[Measures].[Count in Version]
)),
-- show 0 only when any activity in current period
CASE WHEN NOT IsEmpty(
[Measures].[Count in Version]
) THEN 0 END
)
The chart that is produced shows the issue count for issues created in a week that have been assigned to a specific [Fix Version].
How can I access/reference the date an issue was assigned to a Fix Version?
Robert
Hi,
eazyBI cannot track the changes for the multi-value fields, unfortunately. We have this feature in the backlog but have not yet found a feasible solution for such a feature.
Kindly,
Janis, eazyBI support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.