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.
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
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.