nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create a Epic report dashboard

Jeremy Spencer_dgo5qo

Hello everyone, I am trying to create a 2d Dashboard table similar to the image below. Would this be possible? If yes, can someone help with the JQL design for this. I need to call out current and future sprints in the top row. Also somehow show the planned delta columnG. The story points planned would be rolled up from EPIC-Link I imagine, then each sprint column points would come from preassiging stories into the future sprints. Thanks for the help and you'll be a life saver. Thanks

2023-10-12 13_40_52-MOCK UP EPIC REPORT - Google Sheets.png

Accepted answers

Fabian Lim

Hi @Jeremy Spencer

Welcome to the community!

Unless you have a new customfield that captures story points completed for every sprint in your epic, you will not be able to recreate this table.

I suggest you look into eazyBI which may be able which will allow you to track information more dynamically. This is an example, it's not specifically what you are looking for but eazby support staff can help you build what you may be looking for: https://eazybi.com/accounts/1000/cubes/Issues/reports/166439-story-points-progress-and-velocity-by-sprints-in-epic