Reporting on amount of transitions between 2 status?

I’m trying to find out how to go about this.
I need to report on each ticket in our jira board, the amount of times it has changed status between InProgress and InTesting.
Would there also be a way to somehow filter this again so that it would only show items that have gone between these 2 status more than once?


There is the standard measure of the eazyBI data cube for counting the transitions of the issue between statuses. You can use the Transitions from status or Transitions to status measures together with the Transition or Transition status dimensions to count the number of times the issue transitioned between the statuses.

If you are interested in counting the direct transitions from In Testing to the In Progress then the formula would be the following:

([Measures].[Transitions to status],
 [Transition].[In Testing => In Progress])

The simplest way to filter the issues by this measure is to apply the filter on the report rows:

Janis, eazyBI support