This might be a bit special as I asked around and no one seem able to find a solution… we need a table to show how many days were used in transition status for each of the status assignee; this can be achieved using below configuration
Columns = Measures = Days in transition status
Rows = Assignee or Transition Author
Average days = [days in transition status]/[transitions from status]
But this does not include the issues which are still in the corresponding status, have not moved onto next status; for e.g. if an issue is left in OPEN over x days, it will not be included in the table.
How can we include the issues data left in the status?
If that is possible, then the “Average days = [days in transition status]/[transitions from status]” would be invalid as there is no “transitions from status” for that issue… how can we deal with it now?
Please kindly let us know… Much appreciated!