Average days in trainsition

Questions & Answers
1

Hi,
I created a measure to calculate issues’ average days in a status which are closed during a certain period of time ,like this

image
image763×405 8.1 KB

but sometimes this value is longer than Average closing days ,like this：

image
image409×566 9.3 KB

could you please give me some directions , thanks a lot in advance!

2

The formula is technically valid. However, there might be differences what issues are pulled in by the Average closing days and by this custom measure.

Measure days in transition status in a tuple with the particular transition will pick the sum of time in status Open only for cases when a status change was done from Open to In Realizing. If issues were closed via any other status change (for example, quick resolution skipping all the workflow) it will impact the average result of closing days.

You can select one particular period in the report and use Issue dimension on Rows. Compare results of both measures per issue. There should be some issues with average closing days and empty values for average open_in realizing day

Here are suggested solutions:

  1. You can consider using Transition status instead of Transition to count total time spent in status Open. See similar calculations in this example report in our raining account.

  2. You can consider using 0 for all closed issues with no values in average open_in realizing day.

Please replace:

    CASE WHEN 
       [Measures].[Issues closed] > 0
     THEN
        CoalesceEmpty(
           ([Measures].[Days in transition status],
            [Transition].[Open => In realizing],
            [Time].CurrentHierarchy.DefaultMember)
        , 0)
    END

instead of

  ([Measures].[Days in transition status],
  [Transition].[Open => In realizing],
  [Time].CurrentHierarchy.DefaultMember)

Daina / support@eazybi.com