Filter in/out undesirable label data from Jira Issue JQL

[David Hartje]

We have a Jira JQL filter that shows results only for specific values in the "Label" field, but unfortunately the resulting reports display that plus counts for every other "Label" field type value as well.  For example, our Label values might include (a), (a1, b), (a, b2), (c, d), (a1, d2) etc. and we can filter on issues that always have a(something) as a value.  The problem is when displaying the results in a table, we also get results for issues that have more than just the "a(something)" values, such as (b, b2, c, d, d2) if those values are ALSO listed in the same issue that as the "a(something)" value.

Is it possible to create a report that only displays results for "a(something) and "hides" the results of all the other label types?

[Nauris Malitis]

Hi @David Hartje 

We missed your post, and I apologize for that!

You can define a new measure in the Measures dimension using a formula like this:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issue labels] = "a(something)"
  ),
  CASE WHEN
    [Measures].[Issues created] > 0
  THEN
    1
  END
)

This will count the number of issues that have only this one label.

Let me know if you have any additional questions on this!

​Best regards,

​Nauris / eazyBI support