eazyBi - Measure with status Open and Closed only bofore date

Nicolás Figueroa_mhev1c

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)

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