Help with JQL to get a count of issue where numeric custom field is greater than 1

Questions & Answers
1

I need help converting the following into a calculated member, please? I know I am missing something cause the counts are off.

JQL: project = PROJA AND type = Review AND "Review Required" = Yes AND "Failed reviews" > 1

2

Hi @stephen.crandell,
Is the JQL part ‘“Failed reviews”>1’ a customfield in your Jira? Have you imported this field as a measure in the eazyBI?

In that case, you could use this type of measure (but please check the spelling of all formula parts by using autocomplete):

NonZero(
  Count(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      ([Project].[PROJA], 
      [Issue Type].[Review],
      [Review Required].[Yes],
      [Measures].[Failed reviews created])>1
    )
  )
)

best,
Gerda // support@eazyBI.com