Trying to calculate time in a group of statuses (let's call it phase), but also include 'until now'

Questions & Answers
, ,
1

Hey team! Hope all is well!

I’ve created some calculated measures to group certain statuses and call them a ‘phase’ (such as development phase, prioritization phase, etc) and it’s working fine like this:

ex:
Days in tech Prioritization:

([Measures].[Days in transition status], [Transition Status].[Plan Development])
 +
 ([Measures].[Days in transition status], [Transition Status].[Hold for Development])
 +
([Measures].[Days in transition status], [Transition Status].[Update Requirements])

However, I noticed that if the issue is in the status ‘Update requirements’ currently, then the number of days in update requirements isn’t added to the count, only the days in the previous two statuses, so it looks like the above measure only counts when an issue is moved FROM that status.

Is there a simple way to add to the above calculation that also includes ‘until now’, if the issue is still in one of those statuses?

As another example, this is the ‘days in development phase’ measure, it has a lot of statuses, which is why I’d like a simple way to add a ‘until now’ to them:

([Measures].[Days in transition status], [Transition Status].[In Progress])
 +
 ([Measures].[Days in transition status], [Transition Status].[Development])
 +
([Measures].[Days in transition status], [Transition Status].[Testing])
 +
([Measures].[Days in transition status], [Transition Status].[QA In Progress])
 +
([Measures].[Days in transition status], [Transition Status].[Rework])
 +
([Measures].[Days in transition status], [Transition Status].[Rework In Progress])
+
([Measures].[Days in transition status], [Transition Status].[Code Committed])
+
([Measures].[Days in transition status], [Transition Status].[Hold for UAT])
+
([Measures].[Days in transition status], [Transition Status].[Merge to UAT])

Thank you so much!

2

Hi @Bianca

You are on the right track with the idea, only you need another measure instead of “Days in transition status”.
You may want to check out the demo report Issue days in selected status - Issues - Jira Demo - eazyBI
and find there a measure “Days in transition status till now” that calculates days in status, including the current status.
Recreate such a measure in your instance (copy the formula from the demo account) and use it in tuples instead of “Days in transition status”, like the following:

([Measures].[Days in transition status till now], [Transition Status].[Plan Development])
 +
 ([Measures].[Days in transition status till now], [Transition Status].[Hold for Development])
 +
([Measures].[Days in transition status till now], [Transition Status].[Update Requirements])

As this measure iterates through issues, it might be slow for larger issue amounts.

Best,
Ilze, support@eazybi.com