nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL + Dashboard Question: Would like to show BUG and STORY ratio per sprint in the same sprint board

Learning123

Hi expert! Please help!

I would like to create a chart maybe using "Rich Filter Time Series Chart" or "Rich Filter Simple Gauge", just to show the ratio between BUG type and STORY type of Jira issues/tickets in the past completed sprints (btw, can it be past AND current sprint?) within the same Jira board?

If using the "Rich Filter Time Series Chart", the bottom time stamp could be sprint name or #, and the left side y-axis could be story counts or % between STORY or BUG type

Pretty much I need to show what ratio the team is currently completed or future planning between 2 different types of Jira issues. Does that make sense?

Accepted answers

All comments

Walter Buggenhout

Hi @Learning123 and welcome to the Community!

If you create 2 saved filters (one for the current sprint, 1 for the previously closed sprint(s), you might already come quite close with 2 regular pie charts on your dashboard:

Screenshot 2024-12-14 at 10.03.17.png

As a filter for the current sprint, I used:

Project = ABC and Sprint in currentSprints()

For the previous sprints, I used this alternative:

Project = ABC and sprint in closedSprints()

Hope this helps!

Danut M _StonikByte_

Hi @Learning123,

I'm afraid that this is not possible to do with the Jira's default gadgets. Also, I am not familiar with Rich Filters plugin.

But if you consider the option of using another plugin, for sure you can easily do this by using the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app.

To achieve the above, the gadget should be configure like this:

Instead of percentages, it can also display count of issues, sum of story points and many other statistics.

Danut.

Learning123

Thanks for the info! Unfortunately, our company not support this gadget.... cannot use this method.... Are you able to think about other gadget?

Learning123

Thanks for the info! btw, if u know we could break now the closed sprints in the past? Like, each sprint per pie chart? Ultimate goal here is to actually see the trend in the past sprints what ratio between BUG and STORY. If we could list out all sprints in the past (hand pick let's say 3 previous closed sprints), how to make it into a graph/chart to see the trend?

Alexey Pavlenko _App Developer_

Hi @Learning123 ,

You can achieve it manually via constructing JQLs

issuetype = bug and sprint = %YOUR_SPRINT%

issuetype = story and sprint = %YOUR_SPRINT%

and adding them to some of the JIRA gadgets, for example, Two Dimensional Filter Statistics or Pie Chart. You will have to constantly update sprint IDs.

If you would like to have an automated solution, you can use the app I have developed - Multi-team Scrum Metrics & Retrospective. You can choose how many of the last sprints, months, quarters, half-years, or years you would like to see this ratio for, and the app will update the view automatically with each new sprint started. Active sprints supported.

Best regards,
Alexey

Vitalii_Bobak_SaaSJet

Hi @Learning123

Also you can easily get BUG and STORY ratio per sprint in the same sprint board by Sprint Performance Report.
Report is available throw the Time In Status add-on.

Знімок екрана 2024-12-17 о 17.05.11.png

Also add-on offers more built-in and custom reports for Scrum Teams which you can get by grid, charts or dashboards.

Frame 1021.png

You can also book a live demo - we'll show you the application inside out and answer all your questions.
Add-ons developed by my team.

Have a nice day and happy sprinting 🥳

Learning123

thx for the info! Could that BUG/STORY ratio bar showing in a chart that we could compare all the sprints in the past?

Vitalii_Bobak_SaaSJet

@Learning123 Yes, you can see this for any past sprint.
But just for the clarification, by “chart“ you mean gadget in dashboard or just visual representation?

Learning123

Thanks for the quick reply! the end goal is to see the ratio trend from the past sprints (at least 5 sprints). The trend would be a chart (see example below from Created vs. Resolved Chart for bugs) that visually see the percent or the count trending up or down between BUG and STORY. Currently looking to the support in Jira Dashboard gadget since there are lots of options possibly support this request.

Gizem Gökçe (OBSS)

Hello @Learning123 ,

Unfortunately, Jira's default gadgets do not support the type of detailed ratio analysis you're describing, and I'm not familiar with the specifics of the Rich Filters plugin either. However, if you're open to using a third-party app, I highly recommend Timepiece - Time in Status for Jira, developed by my team at OBSS.

With Timepiece, you can:

Group issues by sprint and issue type (e.g., BUG vs. STORY).
Calculate and visualize trends, such as the ratio between BUGs and STORYs, across past and current sprints.
Create various graphs & charts to visualize it

Timepiece allows you to generate powerful insights and display metrics over time to understand your team's performance and planning. If you'd like to explore this solution further, feel free to check out Timepiece on the Atlassian Marketplace or schedule a demo with us for a walkthrough of the app's features.

Hope it helps,

Gizem

Mehmet A _Bloompeak_

Hi @Learning123,

If you prefer using a marketplace app, you can easily get BUG vs STORY ratio using Reports - Charts and Graphs for Jira app as can be seen in the screenshot below .

bug-story ratio.png

It shows bug ratio trend by issue creation month. The app is super dynamic. Once you change X-axis from "Created(month)" to "Sprint", then you can get the trend by sprint.

Here is our live demo dashboard where you can see and modify sample reports and play with them.

If you have any questions, feel free to schedule a demo with us.

Learning123

Thanks @Mehmet A _Bloompeak_ for chiming in! BTW, can we pull the data per sprint board which contains multiple (more than 5 Jira projects)? The sprint board JQL could be: Project in (X, Y, Z) AND labels = "TeamA"? We start each sprint in sprint board

Mehmet A _Bloompeak_

Hi @Learning123 ,

Yes, the data source of the chart can be any JQL. You can type your own JQL as in the screenshot below.

JQL suport.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

dashboard

gadget

unknown-hosting-type

jira-unknown-hosting-type