Excluding statuses in hierarchy

[Johanbehl]

This is my advanced Jira roadmap hierarchy.

• Feature
• User story
• Tasks

I have a bar graph that shows me all open Vs. closed tasks for a feature. How do I exclude the features that are in a specific status (Done) from this bar graph?

[Fabrizio]

Hi Johan,

I do not see your part of the code related to the calculated measure for the tasks.
However I propose you to use the except function (more info)

You can also filter the tasks by adding a condition to your filter that Features should not be closed

Finally you can use Page to exclude the Issue Type features and done

Kr,
Fabrizio

[gerda.grantina]

Hi @Johanbehl ,
If you are using an Advanced roadmap hierarchy, you could create a Feature status dimension and filter all your children’s issues based on this dimension. You can create an aggregate member using Except() in the newly created dimension.
See this community post on how to create an issue link field dimension:

Issue link field dimensions don't include parent issue

Hi @Stuart, You are very close to the solution, the line you need to change is issue_key_column = "customfield_16400" to this one issue_key_column = “jpoh_parent_3”. [[jira.issue_link_field_dimensions]] name = "Feature Release" source_dimension = "Fix Version" issue_key_column = "jpoh_parent_3" group = "Linked issue dimensions" There is also the possibility to use different levels from Portfolio with this line - jpoh_parent_3, the number at the end is counted like this: [Issues_-Jira_Portfo…

Best,
Gerda // support@eazyBI.com