How to create a weekly sprint progress view in Jira ?

[Agarwal, Akshit]

I want to create a weekly sprint progress view in Jira Dashboard but don't see any option to do it. I had tried adding a two dimensional statistic gadget but I don't see planned start date in the LOV for x-axis and y-axis. Can someone help me on this ?

[Alexey Pavlenko _App Developer_]

Hi @Agarwal, Akshit ,

You have multi-week sprints and you want to track sprints on a weekly basis? If so, I think you need to derive the tasks you need using certain criteria in a JQL filter. Such as 

Sprint = "%YOUR_SPRINT%" AND resolutionDate >= %END_DATE_OF_YOUR_WEEK% resolutionDate <= %START_DATE_OF_YOUR_WEEK%

After that you can create several gadgets (2d statistic gadgets or Filter Results, for instance) per week.

The other option might be to use the app I developed - Multi-team Scrum Metrics & Retrospectives.

With it, you can do the same - apply your custom JQL filters, but you will get a more granular and analyzable view.

3 boards/teams in the same view, 1 period selected for analysis:

3 boards/teams in the same view, all periods are clicked for average metrics:

Best regards,
Alexey

[Danut M _StonikByte_]

Hi @Agarwal, Akshit,

Welcome to the Atlassian Community!

You could also try the Sprint Burndown Chart and Sprint Health gadgets of Jira. They can be very helpful.

However, if you need more detailed insights or want to build a more effective Sprint Progress dashboard, you may need additional gadgets. In that case, you can search for and install an app (plugin) from the Atlassian Marketplace.

If you want to try an app, I would also recommend looking over our Great Gadgets app.

This app offers all you need for building an effective Scrum dashboard. Take a look over this article: https://community.atlassian.com/forums/App-Central-articles/8-gadgets-for-a-powerful-Scrum-dashboard-in-Jira/ba-p/1683063

Specific for your case, I would recommend the Sprint Burndown Burnup Chart gadget. It can display the progress along the sprint, and offers a Sprint Report on its Data tab.

For displaying custom stats & numbers, your could look at the Pivot Table & Pivot Chart gadget, which is much more powerful than Jira's Advanced Issue Filter Statistics gadget. 

If you need any help with the setup of these gadget, feel free to contact support@stonikbyte.com. 

Danut.  

[Mariia_Domska_SaaSJet]

Hi @Agarwal, Akshit 

Atlassian’s documentation says the Two-Dimensional Filter Statistics gadget only supports these custom field types for the X and Y axes: 'Group picker', 'Multi select', 'User picker', 'Select list', and 'Version picker'. You can read more here: https://confluence.atlassian.com/spaces/JIRA042/pages/231932552/Adding%2Bthe%2BTwo-Dimensional%2BFilter%2BStatistics%2BGadget?utm_source=chatgpt.com

Date fields, including custom fields such as “Planned start date,” are not supported. They won’t appear in the dropdowns.

My point, the closest built-in options are to use JQL, for example:

project = Marketing_demo AND sprint in openSprints() AND "Planned start date" >= startOfWeek() AND "Planned start date" < endOfWeek()

And use:

• Created vs Resolved gadget
• Filter Results gadget

If you’re interested in trying a Marketplace app, you might want to check out AI Apps Builder for Jira. I’m part of the team that works on it.

With it, you can create custom Jira gadgets and reports just by describing what you need in plain English, rather than trying to make existing gadgets fit your needs.

For example, I made a sprint health and progress gadget to help track the sprint.

You can try making your own dashboard by writing a prompt like this:

“Create a weekly sprint progress dashboard showing issues grouped by Planned Start Date. Display progress per week with completed vs remaining work.”

If you want to see more examples of dashboards made this way, I’ve shared some real prompts and first results in these articles: https://community.atlassian.com/forums/App-Central-articles/Tired-of-Manual-Reports-Let-AI-Create-Custom-Jira-Dashboards/ba-p/3143686

[Derek Fields _RightStar_]

Describe what you want to see in your report. That would be helpful in trying to answer your question.