Time in status & time between status for reopened issues

Hi there!

Quick question. For workflows that allows an issue to be reopened, how does eazybi calculates the time in status / time between status if the issue passes through each status more than one time? This historical data is imported within eazybi?


Julio Oliveira

Hi @Julio_Oliveira,
There are several predefined historical measures in eazyBI that you can use:

  1. “Days in transition status” - shows how many days the issue has stayed in status from “Transition status” dimension.
  2. “Average days in transition status” - shows how many average days that issue stayed in status from the “Transition status” dimension. It is calculated when an issue is transitioned from this status (when the “Transitions from status” measure is recorded) and will be shown on the Time dimension on the date when the transition from this status happened.

In case when issue passes multiple times one status, then the first measure shows the sum of all those transition days. But the second measure divides the sum with the count of how many times the issues have moved from the status.

See more here about the available historical measures on the eazyBI documentation: Import issue change history

Another option that you can use is to define and import issue cycles in the data source import options where you can aggregate multiple statuses as one cycle and then a set of predefined measures for this cycle will be created during the import: Issue cycles

Gerda // support@eazybi.com

Awesome! Thanks Gerda!

1 Like