# Progress bar per initiative based on closed vs remaining underlying story points **URL:** \ **Category:** Questions & Answers\ **Created:** [June 22, 2022, 6:09pm UTC](https://community.eazybi.com/t/progress-bar-per-initiative-based-on-closed-vs-remaining-underlying-story-points/9863 "2022-06-22T18:09:35Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![drewwiseman](https://community.eazybi.com/user_avatar/community.eazybi.com/drewwiseman/32/7450_2.png) [@drewwiseman](https://community.eazybi.com/u/drewwiseman)\ **Post date:** [June 22, 2022, 6:09pm UTC](https://community.eazybi.com/t/progress-bar-per-initiative-based-on-closed-vs-remaining-underlying-story-points/9863/1 "2022-06-22T18:09:35Z")
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](https://community.eazybi.com/t/progress-toward-completing-the-epics-in-open-initiatives/613): > > 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 ---
**Author:** ![drewwiseman](https://community.eazybi.com/user_avatar/community.eazybi.com/drewwiseman/32/7450_2.png) [@drewwiseman](https://community.eazybi.com/u/drewwiseman)\ **Post date:** [June 27, 2022, 1:14pm UTC](https://community.eazybi.com/t/progress-bar-per-initiative-based-on-closed-vs-remaining-underlying-story-points/9863/2 "2022-06-27T13:14:33Z")
@es_eazyBI How can I get some traction on this and input from the eazyBI in-house experts? Thanks! ---
**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:** [June 30, 2022, 8:20am UTC](https://community.eazybi.com/t/progress-bar-per-initiative-based-on-closed-vs-remaining-underlying-story-points/9863/3 "2022-06-30T08:20:52Z")
Hi @drewwiseman, If the **Advanced Roadmaps** is used, you need to import **Parent Link** and **Epic Link** fields and then after the data import “Advanced Roadmap” hierarchy is created based on the Jira configuration (on the Cloud you need to enable the integration and add the hierarchy configuration, see [here](https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/advanced-roadmaps-custom-fields#AdvancedRoadmapscustomfields-JiraCloud)). Also, in this Community article you can learn more about [additional issue hierarchies](https://community.eazybi.com/t/how-to-create-an-additional-issue-hierarchy/9793). After that you can create a custom measure in the Measure dimension to roll up the progress. See an example here using “Issues resolved %”: [Issue Epic Gantt Chart - Issues - Jira Demo - eazyBI](https://eazybi.com/accounts/1000/cubes/Issues/reports/78204-issue-epic-gantt-chart) Kind regards, Gerda // [support@eazyBI.com](mailto:support@eazyBI.com) ---
**Author:** ![TJohnson](https://community.eazybi.com/letter_avatar_proxy/v4/letter/t/5fc32e/32.png) [@TJohnson](https://community.eazybi.com/u/TJohnson)\ **Post date:** [June 6, 2023, 8:32pm UTC](https://community.eazybi.com/t/progress-bar-per-initiative-based-on-closed-vs-remaining-underlying-story-points/9863/4 "2023-06-06T20:32:13Z")
The example provided does not leverage the Advanced Roadmaps configuration. Can you provide an example that uses the data after making the configuration/import changes noted in your first paragraph?