Retroactive Backlog age

Is there any way to view the backlog of backdated issues?

Example: Backlog age as of December 31, 2021.

Today I have a dimension called Backlog Average Age (working days)
which shows the age of the backlog.

===============================================
CASE WHEN [Measures].[Open issues] > 0 THEN
Avg(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue] ),
DateBeforePeriodEnd(
[Issue].CurrentMember.get(‘Created at’) ,
[Time].CurrentHierarchyMember) AND
NOT DateBeforePeriodEnd(
[Issue].CurrentMember.get(‘Resolved at’)
,
[Time].CurrentHierarchyMember)
) ,
CASE WHEN
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember) > 0
THEN
CASE WHEN DateInPeriod(Now(), [Time].CurrentHierarchyMember)
THEN DateDiffWorkDays([Issue].CurrentMember.get(‘Created at’),
Now())
ELSE DateDiffWorkDays([Issue].CurrentMember.get(‘Created at’),
[Time].CurrentHierarchyMember.NextStartDate)
END
END
)
END

Hi Fabio,

If you are looking for average age of open issues at the end of each time period, then the formula is the correct one (it seems this is measure “Average age of open issues” used in demo report Average age till resolution report - Issues - Jira Demo - eazyBI)

Use it with the Time dimension in report rows: the calculation looks for open issues at the end of each selected time period and calculates average days for then open issues from their creation until the end of the selected time period. Select month “Dec 2021” (or a year “2021”), and you would get the average age from all issues which are not yet resolved on December 31, 2021, regardless of when they were created.

What is still missing there to solve your use case?

Ilze, support@eazybi.com

1 Like

Hi @ilze.leite,
Thanks for the tip.