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

Robert Pollina
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 5, 2017

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

2 answers

0 votes
Janis Plume _eazyBI_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 17, 2021

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

0 votes
Deleted user November 16, 2021

Watching this for the answer.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events