# Sum of stories's Story Points

**URL:** <https://community.eazybi.com/t/sum-of-storiess-story-points/10974>\
**Category:** Questions & Answers\
**Created:** [November 10, 2022, 4:11pm UTC](https://community.eazybi.com/t/sum-of-storiess-story-points/10974 "2022-11-10T16:11:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cdemez](https://community.eazybi.com/user_avatar/community.eazybi.com/cdemez/32/7354_2.png) [@cdemez](https://community.eazybi.com/u/cdemez)\
**Post date:** [November 10, 2022, 4:11pm UTC](https://community.eazybi.com/t/sum-of-storiess-story-points/10974/1 "2022-11-10T16:11:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [November 25, 2022, 4:33pm UTC](https://community.eazybi.com/t/sum-of-storiess-story-points/10974/2 "2022-11-25T16:33:39Z")

</div>

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](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-software-custom-fields).

 ![Epic_hierarchy](https://community.eazybi.com/uploads/default/original/2X/f/f79d4627eaed0ef82844aae73b566a107ff4046d.jpeg)

best,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![mick](https://community.eazybi.com/user_avatar/community.eazybi.com/mick/32/9331_2.png) [@mick](https://community.eazybi.com/u/mick)\
**Post date:** [March 24, 2023, 4:03pm UTC](https://community.eazybi.com/t/sum-of-storiess-story-points/10974/3 "2023-03-24T16:03:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [March 27, 2023, 11:42am UTC](https://community.eazybi.com/t/sum-of-storiess-story-points/10974/4 "2023-03-27T11:42:37Z")

</div>

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](https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/issue-link-field-dimensions)

best,  
Gerda