How to create a Epic report dashboard

[Jeremy Spencer]

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

[Fabian Lim · Accepted solution]

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

Regards,

Fabian

[Jeremy Spencer]

Thanks Fabian.

I just found out we do have Rich Filter gadgets. Wondering now if these can do the job? Example Rich Filter Statistics Gadget?

[Fabian Lim]

Rich filters is good too, but I don't know if it will sum up the stories that belong to an epic though.