eazyBi - Measure with status Open and Closed only bofore date

[Nicolás Figueroa]

Hello Community,

Im 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, resolved, rejected) status, and show only Closed ones 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 in advance.

[Janis Plume (eazyBI) · Accepted solution]

Hi,

this formula gives the issues currently not in any of those statuses if you created it as a measure.

Perhaps, a bit more readable way of this solution would be to create this member in the Status dimension (name it "Open statuses") and use it in a measure like this:

([Measures].[Issues created],
[Status].[Open statuses])

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

[Nicolás Figueroa]

Hello @Janis Plume (eazyBI) , thanks for your response. 

Finally I use a different way to obtain what I want.

But your solution works great too!

Have a nice day.