Hi there,
I want to create the following table:
(rows: the different stati of issues, columns: 1 day/2 days/3 days)
The table should give the number of issues that remained 1 day/2 days/3 days in a certain state.
Intuitively I would say for the 1 day selection:
NonZero(
Count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Workdays in transition status] <=1)
))
However, that didn’t work.