Interative JIRA Dashboard to fetch SUM of Story points or effort estimate of a particular team

[Ravi Nandan Venkatapuram]

Is there any way to create an interactive dashboard where in I can get SUM of story points delivered or SUM of effort estimate by a team for a particular period or month, I should be able to give date range or month as input and generate the SUM of story points delivered or SUM of effort estimate.

Here is an example JQL through which I created static dashboard to fetch the SUM of story points delivered or SUM of effort estimate by a team
Project IN (XXX) AND status in (Done, "Deployment Ready") AND resolutiondate >= "2025-12-01" AND <= "2025-12-31"

[Rahul_RVS]

Hi @Ravi Nandan Venkatapuram 

If you would be interested in a mktplace app to sum up your project data, I can suggest one from our portfolio 

Dashboard Charts for Jira

The app allows you to build interactive Jira dashboards with powerful charts, gadgets, and reports. Visualize issue progress, team workload etc

There are multiple configuration and customization options which the apps provides. Some of the sample charts are as below.

[Mariia_Domska_SaaSJet]

Hi @Ravi Nandan Venkatapuram 

With standard Jira gadgets, you can create a saved filter with that JQL, than use gadgets that show sum of Story Points like "Filter Results". But you can't recalculate the “SUM of Story points”  without editing the filter.

If you’re open to using a Marketplace app, please check out No-Code Apps Creator for Jira. It’s an AI-powered app that lets you create custom dashboards and gadgets simply by describing what you need in plain English — no scripting, no JQL-heavy setup. 

[David Nickell]

REST API + Power BI = Unlimted Reporting options

Think of this as providing the raw data for a pivot table. 

In the example below --this shows estimates and effort;  easily filtered by team or any other field in your issues as needed.

In the second screenshot, the report has data rolled up by month and week

This final screenshot shows the ability to use any field for aggregation (Group by). 

---

If you'd like help tailoring some Power BI Reports to your specific needs, let me know.   The REST API is free to you and provided by Atlassian.     The Power BI logic which also works in Excel is something I've created by it's pretty much open source if you spend the time to figure it out.