Hi @chennecke
Welcome to eazyBI community!
You are almost there with the calculated members in the Transition status dimension as well as the logic behind the average calculation.
Now, you may want to iterate through all issues having been in those statuses, calculate the days spent in those statuses for each issue, and then get the average from all those issues. For iterating through issues, you would use Descendants() function, and then use aggregate function Avg() to calculate the average.
Avg(
--set of issues having been in at least one of the selected statuses
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Transitions from status issues count]>0
),
--for each issue, days spent in the selected statuses
[Measures].[Days in transition status]
)
In the report Pages, select one or another calculated Transition status member!
To get the idea why Descendants() function could be needed, you may check out another community thread: What's the difference between Tuple and Descendants
Best,
Ilze, support@eazybi.com