Calculate Feature Progress Based on Cumulative Story Points of Linked Epics

Questions & Answers
1

I have the following Jira hierarchy and link structure:

  • Feature → has custom links "depends on" to one or more Epics

  • Epic → has Stories as child work items

I want to calculate the progress of a Feature based on cumulative story points of stories linked to its corresponding Epics.

What i have working so far

I can calculate progress based on number of completed vs total stories:

Number of completed stories per Feature:

Count(

Filter(

\[issue\].CurrentHierarchyMember.GetLinkedMembers('depends on'),

\[Issue\].CurrentMember.Get('Issue type ID') = 10000  AND

NOT IsEmpty(\[Issue\].CurrentMember.Get('Closed at'))

)

)

Number of total stories per Feature:

Count(

Filter(

\[Issue\].CurrentMember.GetLinkedMembers('depends on'),

\[Issue\].CurrentMember.Get('Issue type ID') = 10000

)

)

Progress %:

CASE WHEN [Measures].[Total epics (linked)(good)] > 0 THEN

100 * [Measures].[Completed (linked, closed at) (good)] / [Measures].[Total epics (linked)(good)]

END

What I need help with

When I try to calculate progress based on story points, the following script does not work:

Sum(

Filter(

\[issue\].CurrentHierarchyMember.GetLinkedMembers('depends on'),

\[Issue\].CurrentMember.Get('Issue type') = "Story"  AND

IsEmpty(\[Issue\].CurrentMember.Get('Closed at'))

),

Sum(

Descendants(\[Issue\].CurrentMember, \[Issue\].\[Issue\]),

\[Measures\].\[Story Points created\]

)

)

How can I correctly calculate cumulative story points for all stories under Epics linked to a Feature?
Any recommendations or examples would be greatly appreciated!

2

Hi,

The solution to this use case depends on how the report is configured and how the depends on link is created.

I would question whether this formula gives the count of stories per Feature:

Count(
  Filter(
   [Issue].CurrentHierarchyMember.GetLinkedMembers('depends on'),
   [Issue].CurrentMember.Get('Issue type ID') = 10000  AND
   NOT IsEmpty([Issue].CurrentMember.Get('Closed at'))
  )
)

If the report uses the Feature level issues in the report rows, this count gives the issues (with type ID 1000) that have closed date and are directly linked to the feature (not the story count of linked Epics).

Please share more details on how your report looks and how you have configured the depends on link (scrrenshots would be fine), so I can provide more detailed guidance.

Kindly,

Janis, eazyBI support

3

thank you Janis.

In my setup, stories are not child of a Feature. below is the tickets relationship:

  • Feature → use the link ‘depends on’ to link to one or more Epics
  • Epics has Stories as child work items

the goal is to calculate cumulative total story points of Stories that linked to Epics that linked to Feature

Your script will generate list of epics and it work good. Thanks.

I had a typo in my post but i don’t know how to correct it.

Q: First, i’m trying to calculate total number of stories under epics that link to each feature. below the script (3 versions) and none of them return the desired value:

Sum(

Filter(

[Issue].CurrentHierarchyMember.GetLinkedMembers('depends on'),
[Issue].CurrentMember.Get('Issue type') = 'Epic'

),

– Version #1

  Count(Descendants([Issue].CurrentMember))

– Version #2

--  Count([Issue].CurrentMember.Chidlren)

–Version #3

--  Count(
--      Filter(
--        [Issue].CurrentMember.Children,
--        [Issue].CurrentMember.Get('Issue type') = 'Story'
--      )
 --   )

)

Any recommendations?