How can I exclude issue by fix version

Questions & Answers
1

Hi, I’m trying to get Issues by [Fix Version] filter.
I would like to exclude “FFN” version from the issue.

Aggregate(
Except([Fix Version].[Version].Members,
Filter(
[Fix Version].[Version].Members, [Fix Version].CurrentHierarchyMember.Name MATCHES ‘^FFN.*’
)))

But this query not exclude issue has multiple version like [FFN, MTO…]
How Can I exclude issue belong to any of “FFN”?

2

Hope this will help.

Aggregate(
Except({[Fix Version].[Fix Version].Members},
{[Fix Version].[FFN],[Fix Version].[MTO]}
)
)

3

Hi @1115 ,

Fix Version is a multi-value field. Thus the Except() function will only filter out issues that have only the particular member (or members) specified.

Depending on the report structure, there are multiple workarounds. If you use the Issue dimension in rows, you can add the “Issue fix versions” property to the report and filter the report rows. See an example below:

Screenshot 2021-04-29 at 13.55.51
Screenshot 2021-04-29 at 13.55.512124×1534 389 KB

And the filtered result:
Screenshot 2021-04-29 at 13.56.10
Screenshot 2021-04-29 at 13.56.101748×1270 259 KB

Without the Issue dimension “Issue” level in the report, a simple subtraction could suffice in some cases. See an example for a calculated measure below:

[Measures].[Issues created]
-
([Measures].[Issues created],
[Fix Version].[Rocket Engineering].[Released].[Version 3.3])

Subtracting the number of issues with the particular version from the total number of issues will give you the desired result.

Other cases may require iterating through Issue dimension “Issue” level members, impacting the report performance.

See more details on calculated measures in the eazyBI documentation page - Calculated measures and members - eazyBI for Jira.

Best,
Roberts // support@eazybi.com

4

Thanks!
Your help saved my time.