Calculate Measures resolved, AVG resolution WD for issues created in currently selected time period only

jvdh.vidaxl · September 27, 2019, 9:32am

I am making a report on the average resolution working days per person in my team. However because we have a very large backlog sometimes issues older than 100 days are solved and these skew the results up unrealistically.
Therefore I’d like to Filter the Measures.Issues Resolved, Average Resolution Workdays and Story points only for the issues that are created in the selected Time Dimension.

I’ve tried all kinds of things but can’t get it to work.
I also saw that apparently you can filter issues (the issue dimension?) on Created date, but also haven’t figured this out.

The following image shows the values for ALL issues that were resolved in Q3 2019, but I need a selection where they were also CREATED in Q3 2019. The Issues resolved should then go down with Story points and also the average Resolution Workdays will be a lot lower.

aalex · October 3, 2019, 1:42pm

Hi,
… I have the same problem with reports that are not issue-based. For reports with issues I found a good solution with the issue created date

first display the measure “Issue created date” (measures/issue properties) in the report
then sort after the Issue created date and
finally remove this column from the report (the filter remains upright).
I would also be grateful for solutions for this problem (select time period for issues created date) without using individual issues
regards
andrea

roberts.cacus · November 12, 2019, 10:49am

Hi @jvdh.vidaxl and @aalex,

To get the number of issues created AND resolved in the period currently on the Time dimension, it is necessary to create a calculated measure that would iterate through all the issues. This could create a performance hit, resulting in the report time-outing. Especially if there are three of those in one report.

Before you try the calculated measure mentioned above, please try to create a tuple of the measure “Issues created” and the Resolution dimension member that defines the desired resolution (resolved, done, etc.). Please have a look at the example below:

([Measures].[Issues created],
[Resolution].[Done])

In combination with the Time dimension in the report, this calculated measure would display the resolved issues to the period the issues were created. The drawback - it doesn’t give any indication on when the issues were resolved.

You could try to do the same with the measure “Story points created”.

For the “Average resolution workdays”, there is no other option than creating a calculated measure that will iterate through all the issues. Please have a look at the formula below:

AVG(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    DateInPeriod([Measures].[Issue created date],[Time].CurrentHierarchyMember)
    AND
    DateInPeriod([Measures].[Issue resolution date],[Time].CurrentHierarchyMember)
  ), [Measures].[Total resolution workdays]
)

Please have a look at a picture of a sample report below where you can compare the results for the calculated measures and the default ones:

Please have a look at the eazyBI documentation page for more information on calculated measures - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/calculated-measures.

Best,
Roberts // eazyBI support