Average Resolution Workdays formula

I want to create a measure similar to average resolution workdays, but measuring the time from when the issue transitions to “In Progress” to when it is resolved.

The topic measure uses a hidden measure “Total resolution workdays”, which if I could see the formula, I think I could modify into a new measure for my purpose.

Thoughts?

Hi,

It is not possible, unfortunately, to modify the behaviour of the Total resolution workdays measure. That is a standard measure and is pre-calculated during the data import.

The recommended approach to try would be the custom measure with the following formula:

Avg(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues resolved]>0
  ),
  DateDiffWorkdays(
    ([Measures].[Transition to status first date],
    [Transition Status].[In Progress],
    [Time].CurrentHierarchy.DefaultMember),
    [Measures].[Issue resolution date]
  )
)

The idea of the formula is that it iterates over all the issues having resolution and takes the average of the difference in workdays between first transition to the In progress status till the issue resolution date.

Kindly,

Janis, eazyBI support