Filter in/out undesirable label data from Jira Issue JQL

David Hartje June 5, 2024

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?

1 answer

0 votes
Nauris Malitis
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 14, 2024

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events