Replicate the Jira Average Age Report

Questions & Answers
1

The Average Age report in Jira shows the average age of unresolved issues. This helps you see whether your backlog is being kept up to date.

I need to create that report in eazyBI so that we can track our progress in reducing the age of our open backlog.

This would be the Average Age of the Open Issues for each time period.

2

Hi,

I think this is a starting point for what you need:

https://eazybi.com/accounts/1000/cubes/Issues/reports/50084-average-age-of-open-issues

2 Likes
3

Yes, that is just what I need. Thank you very much.

4

We have created a Average age chart in JIRA and tried to replicate the same in eazyBI using AverageAgeofOpenIssues Measure. However there is a mismatch in the data.

Please help correct the same. Thanks!

CASE WHEN [Measures].[Open issues] > 0 THEN
Avg(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Open issues] > 0),
CASE WHEN DateInPeriod(Now(), [Time].CurrentHierarchyMember)
THEN DateDiffDays([Issue].CurrentMember.get(‘Created at’),
Now())
ELSE DateDiffDays([Issue].CurrentMember.get(‘Created at’),
[Time].CurrentHierarchyMember.NextStartDate)
END
)
END