EazyBI | How to calculate Aging but remove time in Backlog?

[Nathaniel Bennett]

Hello EazyBI Nation!

My group has a Kanban team that would like an Aging report, but they only care about issues that are on their board and they do not care how long an issue was in the Backlog before they started working on it. I've created a basic Aging report using the demo report on the site, but how do I subtract time in the Backlog status?

Here's an example of how this will be useful: an item was added in the backlog 90 days ago and has only be In Progress for 3 days, but will shows as 93 days old in the Aging report but the team would like that to show as 3 days.

They'll use this report to address In Progress issues that are getting moldy rather than issues with long lead times.

Thanks! 

[Janis Plume _eazyBI_]

Hi Nathaniel,

The following code snippet is for finding the time an issue spent in a specific status:

([Measures].[Days in transition status],
[Transition Status].[Backlog])

It is likely that your formula needs to incorporate this part of the code into it. Other changes could also be needed.

There are several example reports of age in the eazyBI Demo account, could you share the formula behind the calculation of the issue age?

Kindly,

Janis, eazyBI support

[Nathaniel Bennett]

@Janis Plume _eazyBI_ thanks for weighing in!

I used the example Aging report, however Aging Interval is a dimension rather than a calculated measure so I can't open it up and see how its calculated. 

Maybe there's a way to aggregate time in status for the current all previous status states for an open issue? So if an issue is in Status C then calculate Time in Status A + Time in Status B + Time in Status C?

[Janis Plume _eazyBI_]

Hi @Nathaniel Bennett 

Thank you for the update. The standard Age interval dimension cannot be re-designed, but eazyBI allows creating your custom age interval dimensions. Here is a link to the documentation on how to do that: https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Customcalculatedfieldasanintervaldimension

This solution requires processing of issues with a bit of Javascript. The idea behind your case could be to find the issue age since the first (or last, if there can be several) transition from Backlog status (for the issues, that have such transition).

Please, apply for eazyBI support, if you need more assistance with the implementation of the custom age interval dimension.

Kindly,

Janis, eazyBI support