Progress bar per initiative based on closed vs remaining underlying story points

[drewwiseman]

Hi Guys,

I really need to create a report which shows the progress of each Initiative in a PI (FixVersion), based on underlying story points closed vs story points not-closed. We’re using Advanced Roadmaps and Jira together and our hierarchy is Initiative → Epic → Story/Task/Bug. So the Stories, Tasks and Bugs are linked to Epics via the Epic Link and the Epics are linked to the Initiatives via he Parent Link.

I need to track the status of closed stories+tasks+bugs and their associated points that roll up to each Initiative. The request is similar to what Advanced Roadmaps has in the progress bar, but I need this in a report. I’m struggling to make this work and need some guidance. I saw this older thread but it doesn’t look like it was ever completed.

Progress toward completing the epics in open initiatives

I would like to show stacked bar chart, like the one below, showing the relative statuses of the open initiatives we have. I have already figured out how to do so for ALL initiatives - but i would like to only see the initiatives in JIRA that have not been closed, and then mirror the “sprint health” JIRA gadget setup for how many epics in each initiative are To Do, In Progress, or Done. How do I filter out the initiatives that have been closed in JIRA from this list to filter it down to only a…

Can you help me?
Drew

[drewwiseman]

@es_eazyBI How can I get some traction on this and input from the eazyBI in-house experts? Thanks!