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.
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.
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.