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!