Workdays in Initial Status

[jcaristy]

I created 2 Meassures like this

Initial Status
([Issue].CurrentHierarchyMember,[Measures].[Workdays in transition status],[Transition Status].[Open])

In Progress
([Issue].CurrentHierarchyMember,[Measures].[Workdays in transition status],[Transition Status].[In Progress])

The initial alway shows empty. Unless I transtition to the next status and come back.

How can I get the workdays in the initial status?

[martins.vanags]

@jcaristy

See this community post to calculate the time in status including the current status:

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

The measure Days in transition status works for issues that already moved out from the status. Zeros might indicate an issue was moved out of the status shortly after adding to the status (or have transitioned to the same status). It does not include the time since the last status update. The following MDX formula (use it to define a new calculated member in Measures) will include in the calculation also days in the current status: -- days in transition status when issue was in this status in …

Martins / eazyBI support