open / closed tickets in sprint

[David Beran]

I want to add Gadget on my dashboard showing open (grouped multiple statuses - to do, in progress, ...) and closed (done, rejected, ...) tickets in open sprint.

[Rilwan Ahmed]

Hi @David Beran ,

Welcome to the community !!

You can make use of Two dimensional filter statistics or Issue statistics gadget. In these gadget, make use of filter where the JQL is "Project = ABC and sprint in openSprints()"

[Walter Buggenhout]

Hi @David Beran and welcome to the Community!

Dashboard gadgets don't let you group issues by status (out of the box). So you could get closest to the desired result by grouping them in a chart by resolution:

Hope this helps!

[Hannes Obweger - JXL for Jira]

Hi @David Beran

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc. 

I should add that JXL doesn't currently offer a dashboard gadget (but will do so, soon) - but many of our customers simply use a JXL sheet as a "de-facto dashboard".

Any questions just let me know,

Best,

Hannes

[Marc - Devoteam]

Hi @David Beran 

Welcome to the community.

Jira has 3 status categories: To Do, In Progress and Done

Use the within the filter the JQL option "statusCategory".

See the following KB article as well:  how-to-search-using-statuscategory-statuscategorychangedate-function-with-jql 

[Danut M _StonikByte_]

Hi @David Beran,

This can be easily done by using the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app. 

This gadget support statistic by Status Category, which means that it groups statuses in the way you want. All you have to do it to configure the gadget with a filter that returns the issues from the open sprint. 

 

Eventually, you can split data by additional criteria like assignee and display sum of story points instead of number of issues. You can also display percentages.  

If you prefer to see the issues themselves, you could use the Work Breakdown Structure (WBS) gadget offered by the same app. This gadget can display the issues in a tree hierarchy by Epics > Tasks > Sub-Tasks along with their current status colored by  status category.

 

See more examples of these gadget (and the many others offered by the same app) in these articles: 

• https://community.atlassian.com/t5/Jira-articles/Building-a-powerful-Kanban-dashboard-in-Jira-with-Great-Gadgets/ba-p/1664331
• https://community.atlassian.com/t5/App-Central/8-gadgets-for-a-powerful-Scrum-dashboard-in-Jira/ba-p/1683063 

You could start with a 1-month free trial. If you have any questions, feel free to contact support@stonikbyte.com at any time.

Hope this helps.

Danut