Forums

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

How to get distinct Issue Type count when the user story is having multiple sprint assigned ?

Giridharreddy Arkeri June 7, 2021

In the two dimensional gadget (Sprint Vs Status) when I pull a user story with multiple subtask , I am getting double count in both the sprint. Below is the example

User Story 1 - In progress - Sprint 1, Sprint 2 ( Sprint 1 is closed and Sprint 2 is Current)

Sub Task 1 -  Done - Sprint 1, Sprint 2 - Completed in Sprint 1

Sub Task 2 - Done - Sprint 1, Sprint 2 - Completed in Sprint 1

Sub Task 3 -  In progress Sprint 1, Sprint 2 - Started in Sprint 2

Sub Task 4 - To Do - Sprint 1, Sprint 2

Sub Task 5 - To Do - Sprint 1, Sprint 2

I need count of Sprint Vs Status

Status/Sprints         Sprint 1           Sprint 2 

To Do                       2                        2

In Progress              2                        2

Done                       2                        2

Expected Result should be - 

Status/Sprints         Sprint 1           Sprint 2 

To Do                       0                        2

In Progress              0                        2

Done                       2                        0

Can any one tell me how to get the data using JQL query.

1 answer

0 votes
Nic Brough -Adaptavist-
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.
June 7, 2021

This is not the right way to be looking at sub-tasks.  A sub-task is not a sprint item in its own right, it's part of its parent story and has nothing to do with your progress or completion stats.

Your first table in your question, the one with the raw data in it, should read

  • User Story 1 - In progress - Sprint 1, Sprint 2 ( Sprint 1 is closed and Sprint 2 is Current)
  • Sub Task 1 -  Done, but parent is in open, so don't count it yet
  • Sub Task 2 - Done, but parent is in open, so don't count it yet
  • Sub Task 3 -  In progress, but parent is in open, so don't count it yet
  • Sub Task 4 - To Do, but parent is in open, so don't count it yet
  • Sub Task 5 - To Do, but parent is in open, so don't count it yet

Your expected result should then end up as:

Status/Sprints         Sprint 1           Sprint 2 

In Progress              0                        1

Or, maybe

Status/Sprints         Sprint 1           Sprint 2 

In Progress              0                        1 (with 5 subtasks)

Giridharreddy Arkeri June 7, 2021

Hi Nic,

I agree but if I need to know in Sprint 1 what is the count of Issue Type by Status and the same in sprint 2. If a user story is moved from sprint 1 to sprint 2 ideally in sprint 1 it should show only the task which is been closed in sprint 1.  

What is your thoughts on the same.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events