Report bug time in a specific state

[martins.vanags]

@emiliano.sant

We already discussed this in another post

How to calculate Days in transition status including the time in current status

@emiliano.sant Try creating new user-defined calcualted measure using this formula -- days in transition status when issue was in this status in previous times IIF( -- if report uses Status dimension instead of Transition status it should work as well: [Status].CurrentHierarchyMember.Level.Name = "Status" and Not [Transition Status].CurrentHierarchyMember.Level.name = "Transition Status", ([Measures].[Days in transition status], [Transition Status].[Transition status].GetMemberByK…

Please contact to support@eazybi.com and provide more details about your report (what you have so far and what is the definition) if the formula I suggested didn’t work as planned.

Martins / eazyBI