Count transitions to In Progress

Questions & Answers
1

Hi,

I am trying to measure the iterations between developers and QA throughout feature development.
Currently when the QA find a bug during development process, the issue goes back to the status “In Progress”.

For that purpose I would like to calculate the average time each issue transitions to In Progress.
Is that possible, to count several transitions to the same status within the same issue?

2

Hi @zvika,

I presume you have a specific status for QA and then you might as well have the specific “return from QA” transition.
It might be something like “In QA → In Progress”.

In that case, you might see the number of those transitions for the issue or within the issue category using the following expression.

([Measures].[Transitions to],
 [Transition Field].[Status],
 [Transition].[In QA => In Progress])

The number of issues having such transition within the period might be as follows.

([Measures].[Transitions to issues count],
 [Transition Field].[Status],
 [Transition].[In QA => In Progress])

Then you might see the average number of times the issue is returned from QA to Development as follows.

CASE WHEN
-- condition to avoid division by zero
([Measures].[Transitions to issues count],
 [Transition Field].[Status],
 [Transition].[In QA => In Progress])
>0
THEN
([Measures].[Transitions to],
 [Transition Field].[Status],
 [Transition].[In QA => In Progress])
/
([Measures].[Transitions to issues count],
 [Transition Field].[Status],
 [Transition].[In QA => In Progress])
END

Regards,
Oskars /support@eazyBI.com

3

Thank you @oscar.laganovskis,
I think I figured it out.

I actually wanted the average number of times each issue transitions to In Progress (several iterations inside the same issue).

This is what I used to calculated it:

Avg(
  Filter(
    -- Go through issues that have transitions
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    ([Measures].[Transitions to status],
   [Transition Status].[In Progress]) > 0
  ),
  ([Measures].[Transitions to status],
   [Transition Status].[In Progress])
)