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

Question

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.

Giridharreddy Arkeri · Answer

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.

Nic Brough -Adaptavist- · Answer

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)