Create a measure with Closed before date

Hello Community of easybi,

Im very new to eazybi platform in Jira and Im trying to create a page measure where I want to have all the issues that are in a Open(all that are not closed, rejected or resolved) status, and only show Closed Issues before 2021.

Actually I create this,

Aggregate(
Except(
[Status].[Status].Members,
{
[Status].[Status].[Resolved],
[Status].[Status].[Closed],
[Status].[Status].[Rejected]
}
)
)

But I need to show the Closed before 2021, any suggestion?

Thanks.

Hello, anyone can help me with this?

Thanks.

Hi,

There can be several ways to count issues closed before 2021. I would suggest configuring the Issues closed measure in the data import options with all your Closed statuses:

The Issues closed cover all the statues mentioned in the options and you can count issues closed before 2021 like this:

Sum(
PreviousPeriods([Time].[Year].[2021]),
[Measures].[Issues closed]
)

Kindly,
Janis, eazyBI support