Get still “in Open” issues by month in eazyBI and Jira

Imagine, you want a report chart by month and you want to get the issues that are still in “Open” . Then you can create a Calculated Measure using Tuples.

For example, to get from the Issues Created, the Issues in “Open” status. You can use this tuple:

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

Then, to get the Date creation of the Issues you can use this formula:

[Issue].CurrentMember.get(‘Created at’)

Then the formula to get the still Open issues for each month can be this:

NonZero(
Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod([Issue].CurrentMember.get('Created at'),
      [Time].CurrentHierarchyMember) 
	AND
    ([Measures].[Issues created],[Status].[Open]) > 0
 )
)
)