EazyBI? How to calculate total number of Epics that are linked to a specific initiative.

[Christopher Capps]

We are using (Initiative - Epic - Story or Bugs - Subtasks)

This is for a large organization in which we have several large Initiatives running across 25+ Dev teams. I want to create a EazyBI report and dashboard to show progress across each initiative.

I am having trouble building a formula that will gather the total number of Epic Issue Types (not stories issues or any other issue-types).

for additional context here is an example of what I am going for:

	Epics	% of Epics resolved	# of Epics resolved
Initiatives 1	20	10	50%
Initiatives 2	10	5	50%

Likewise, I also want to create a similar dashboard with number of Stories that are linked / support a specific Epic. 

Also need a formula that would gather the number of stories issue types that link to an Epic.

	Stories	% of Stories resolved	# of Stories resolved
Epic 1	20	10	50%
Epic 2	10	5	50%

Any help would be appreciated. 

Thanks!

[Fabian Lim]

Hi @Christopher Capps

This post from the eazybi community has examples that will help you with your requirements: https://community.eazybi.com/t/show-linked-issues-and-link-types-at-the-same-table/2899/2

Regards