Jira "cleanup" stats

[nauris.malitis]

Hi @guya1976

Happy to help!

Have you already imported this hierarchy into eazyBI?
If not, please follow this documentation page and community post to do so:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/additional-issue-hierarchies

How to create an additional issue hierarchy

In Jira, bigger tasks can be split into smaller pieces; thus, we can create task groups that are linked together but can be worked on separately. For example, an Issue can be grouped into smaller sub-tasks. Or an Epic can be split into Stories. eazyBI recognizes those structures and creates different standard hierarchies in the Issue dimension: the default hierarchy with Project → Issue levels, the Sub-task hierarchy with Project → Parent → Sub-task levels, if you have imported the standard Ep…

When you’ve set up the hierarchy, you can use the Issue dimension with the Initiative level selected in the Rows section and use a similar formula as previously to find open issues in resolved initiatives:

Sum(
  Filter(
    Descendants([Issue.HierarchyName].CurrentMember, [Issue.HierarchyName].[Initiative]),
    NOT IsEmpty([Issue.HierarchyName].CurrentMember.Get('Resolved at'))
  ),
  CASE WHEN
  [Measures].[Issues created] > [Measures].[Issues resolved]
  THEN
  1
  END
)

Replace the HierarchyName with the name you’ve specified in the Advanced settings when setting up this hierarchy.

To do the same check with Epic level select in Rows, simply change the level that the formula is pointing towards:

Sum(
  Filter(
    Descendants([Issue.HierarchyName].CurrentMember, [Issue.HierarchyName].[Epic]),
    NOT IsEmpty([Issue.HierarchyName].CurrentMember.Get('Resolved at'))
  ),
  CASE WHEN
  [Measures].[Issues created] > [Measures].[Issues resolved]
  THEN
  1
  END
)

For closed issues with empty resolutions, use the last formula from my previous reply.

Let me know once you have this set up, and we’ll continue with the next metrics.

​Best regards,
​Nauris