Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

open / closed tickets in sprint

David Beran
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 10, 2024

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.

5 answers

3 votes
Rilwan Ahmed
Community Champion
July 10, 2024

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()"

image.png

2 votes
Walter Buggenhout
Community Champion
July 10, 2024

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:

Screenshot 2024-07-10 at 10.53.28.png

Hope this helps!

1 vote
Hannes Obweger - JXL for Jira
Atlassian Partner
July 10, 2024

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:

sprint-status-report.gif

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

1 vote
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 10, 2024

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 

0 votes
Danut M _StonikByte_
Atlassian Partner
July 11, 2024

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. 

 image.png

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.  

image.png

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.

 image.png

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

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events