Average time in defined statuses for whole issue lifecycle

Hello there,

I think that I have a similar requirement.

I need to report on the time from one status to another. The report shall show the average of this for all issues. In one case it is from one status to its direct successor, in the other there are some statuses in between.

I tried the approach posted above in the first reply by Ilze and had the same issue as the other user. Time out.

Another approach was to use Transition as a row and the Measure “Average workdays in transition status” as a column. However, this calculates an average of all statuses per issue.

A third approach was to calculate this via the average (avg function) of the subtraction of “Transition to status last date” minus “Transition to status first date”. I could not make this work either.

What I need in plain words:
Time from one status to a later status in the workflow on issue level divided by the number of issues.

Thank you in advance for any suggestion.

Best regards,
André