Count number of issues that remain x days in certain status

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.

Hi @sstevens!

The formula seems correct for the 1 Day “bucket”. Which part of the report did not work for you?

Could you please make sure you are using the Transition Status dimension on rows? This is the dimension that would work together with the historic value of workdays in transition status (see more https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history).

Lauma / support@eazybi.com