Aggregareted average number of Stories for all completed Epics

[Heldan]

Hi

I’m new to easyBI and want to have a report which summarize the average number of Stories and Story Points for all completed Epics on one row.

I have looked at similar question raised in the community but did not manage to solve my issue with those.

I have manage to create a report which shows this for all Epics regardless in which state they are in. See below.
What I can’t figure out is how to only include this for Epics in Done, and get the result on one row.

I have been able to filter as in second picture below, but that then gives me separate rows for each Epic.

In the end I want one row for which I can use the Gauge charts to visualize.

It feels like a pretty common need, so hope that it is a rather simple solution on this.

So lets see if someone can give me some guidance on this.

[martins.vanags]

Hi @Heldan

Please check how to import issue link field dimensions in eazyBI:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/issue-link-field-dimensions#Issuelinkfielddimensions-EpicStatus

If you import “Epic status” as new dimension and use it as page filter to filter the report, you can skip the “Status” dimension in columns.
That would let you filter all issues below epic by the status of the epic.
Then create a calculated measure using (this formula) and % formatting.

(
[Measures].[Issues created],
[Issue type].[Story]
)
/
(
[Measures].[Issues created],
[Issue type].[Epic]
)

That should calculate the average number of stories per epic for all filtered epics by “Epic status” dimension. Then show it as gauge chart with “only” values option.

Martins / eazyBI

[Heldan]

I got some help from our team who manage our imports.
Below is how we finally solved it.

1. First a user defined measure to define if Epic is done
2. Then a user defined measure counting the number for Stories in status Done.

Note that some information in the attached pictures are masked.