eazyBI: Determining the date when [Fix Version] was assigned to an issue

[Robert Pollina]

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

[Janis Plume _eazyBI_]

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

[Natasha Dixon]

Watching this for the answer.