Sum of stories's Story Points

Questions & Answers
1

Hi,

I have a lot of EPICS, each has multiple stories. I’m looking to compute the Sum of the stories 's “Story Points”. Example

Epic1

  • Story 1 : 5 story points
  • Story 2 : 3 story points

Epic2

  • Story 3 : 2 story points
  • Story 4 : 1 story points

So, the result would be:

Epic1: 8 story points
Epic2 : 3 story points

It is critical to only use the “Issues In Epic” link and not all the other kind of links (parent, blocked, …).
Do you have any idea to compute this ?

Thx

2

Hi @cdemez
You can use Epic hierarchy from the “Issue” dimension together with the measure “Story Points created” to see the aggregated values at the upper level. To have the Epic hierarchy in your Issue dimension, you need to select “Epic link” in your eazyBI data source options.

Epic_hierarchy
Epic_hierarchy1920×650 91.9 KB

best,
Gerda // support@eazyBI.com

3

HI, been trying this approach. which works ok but if I wanted to filter on epics , how can i do this without filtering out the stories the are children of the epic in the hierarchy?

thanks

1 Like
4

Hi @mick ,
In that case, you can create an Epic Link field, so you can filter your report by epic field values, see more in the documentation: Issue link field dimensions

best,
Gerda

2 Likes