Status Condition for Churn

Questions & Answers
1

Hi All,

I am new to EazyBI reporting, a previous Jira admin has created the below code and I would like to add a condition that a particular status is not measured. Is this possible?

NonZero(Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
([Measures].[Issues created],
[Issue Type].[Epic])>0 AND

DefaultContext(
([Measures].[Issues created],
[Issue.Epic].[Epic].GetMemberByKey([Issue].CurrentHierarchyMember.KEY),
[Issue Type].[JD],
[Rehire reason].[Churn])
)>1

)
))

Thank you,
Anudeep

2

Hi @agudipelli

Welcome to the Community! :slight_smile:

Sorry about the late answer, it seems that the topic was posted in the “Tips & Tricks” category, but now we have moved it to the “Questions & Answers” category where we usually answer questions.

You can define a new calculated member “Without Closed” in the “Status” dimension with the following formula that will Aggregate all statuses Except the one you would like to exclude:

Aggregate(
  Except(
    [Status].[Status].Members,
    [Status].[Closed]
  )
)

Next, add this to the tuple in your formula:

NonZero(
  Count(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      (
        [Measures].[Issues created],
        [Issue Type].[Epic]
      )>0 
      AND
      DefaultContext(
        (
          [Measures].[Issues created],
          [Issue.Epic].[Epic].GetMemberByKey([Issue].CurrentHierarchyMember.KEY),
          [Issue Type].[JD],
          [Status].[Without Closed],
          [Rehire reason].[Churn]
        )
      )>1
    )
  )
)

​Let me know if this fits your use case or if you have any additional questions on this!

​Best regards,
​Nauris / eazyBI support

3

Hi @nauris.malitis,

I am sorry for the late reply, I was caught in some priority items.

Thank you for the answer. I will work on that.