How to set a dashboard that shows the story points (total and completes) from close sprints

Question

Dear all,

First of all, I´m new to this forum, this is my first post

I need to set up a Dashboard that shows the story points (completed and total) from closeSprints. Also i need them to be shown by month.

I have being able to identify the Sprint ID of the one from which I need to extract the data from.

Sprints are coming from two different Jira project, one of the works with Story Points and the other with Origin/Remaining Estimate

I have generate hundreds of filters and try with all possibe gadgets availiable in mu company Jira but I still not find a solution.

Can anyone please help me or point me to the right direction to find a solution?

Thanks a lot

Kind regards

Josep Tura · Answer

Many thanks! Looks very useful, I will give it a try!

Marlene Kegel - codefortynine · Answer

Welcome to the community, @Admova,

I am Marlene, product manager of Quick Filters for Jira Dashboards.

With our app you can aggregate all Jira number fields, including story points and original/remaining estimate.

For your use case the "Quick Created vs. Resolved" gadget would work, which could display the created and resolved story points/estimates per month.

To display the total amount of Story Points and estimates you could try the "Quick Issue Statistics" gadget, in combination with the Quick Controller gadget to filter per date or sprint.

You can try out Quick Filters for Jira Dashboards without installation on our demo dashboards.

Alexey Pavlenko _App Developer_ · Answer

Hi @Admova ,

Unfortunately, native JIRA doesn't support this functionality. Even the most custom applications don't support all the functionality you are asking for.

If you can't purchase a 3rd party application and you are ok with the manual approach, I would recommend:

* Use 3rd party gadget with free HTML editing if there is one. If there isn't - you can write your own HTML gadget - it's a simple task if you know how to program.
* Use your filters and export the data to Excel.
* Calculate and aggregate the data you need by month.
* Manually present the data in the HTML gadget and manually maintain it.

If you can purchase a 3rd party application, I would recommend the one I have developed - Multi-team Scrum Metrics & Retrospective. It completely covers all your requests and does it automatically, except for the conversion of Original/Remaining Estimate (you need to choose only one) into Story Points, this should be done by you - preferrably with automations/scripts.

Otherwise, you would need to use 2 setups for the application - one with Story Points and another one with Original/Remaining Estimate.

The bars can be colored based on teams or metrics.

Please note that this application provides many more useful features and is highly adjustable (for example, you can choose different number of months to show, or you can display the report based on years, half-years, quarters, etc.).

Best regards,
Alexey