Story Points closed during Sprints Including Sub-task with Unfinished Parent

Questions & Answers
1

Hi all! first of all thanks for all the effort you put on answering. I apologize for my English as it’s not my first languaje.

I’m here cause I couldnt find a solution to:

I need to do a report with all the story points closed during the sprint, also the one’s on SubTasks whose parents are not yet complete.

It occurs to me that if I iterate over all the parents that get into the Sprint, regardless of the status, I could sum the Story points of their sub Tasks that are closed… but I don’t know how to do that… Please, can someone help me?

Thank you very much for your time!

2

Hi,

I believe the correct measure is “Sprint story points completed” to see the story points for issues resolved in the sprint, but the challenge is to get historical story points for sub-tasks as this Jira doesn’t provide sprint historical data for sub-tasks.

Please check more on this documentation page and find more on sprint scope measures.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-software-custom-fields#JiraSoftwarecustomfields-Sprintscopemeasures

Sprint scope measures are based on issues changelog information about sprint changes. In Jira, sub-task issues do not have such information; sub-tasks are always counted by their parent issue’s last sprint.

To avoid misleading data, exclude sub-task issues from sprint scope reports at all (e.g., add, in the report, filter by “Issue type” dimension standard issue types).

Try contacting support@eazybi.com and provide the report definition of your current report where you noticed the problem. Perhaps there is a workaround for your custom calculation.

Martins / eazyBI

3

Hi Martins. Thanks for your reply, although I’m sad to read that. We can´t Exclude sub-task as they are the work unit for each member of the team with different roles in the completion of a certain Parent Story or Task.
Maybe Jira Should consider letting the projects be planned in a Sub-task level, cause it can be the reality for some teams.
In my spreadsheet I don’t have this problem, I just look at the resolved date for all issues (Subs, task, storys, spikes, etc.) and count them to the Sprint where they get that Closed/Resolved Date. I guess I’ll have to stay there for now.
Thanks anyway!

4

@Luisma
How and where exactly do you see the sprint currently for sub-tasks where they get that Closed Resolved Date?

Martins / eazyBI

5

Hello,
Thanks for asking this question , I am also facing the same problem .

6

Hi Again! sorry for the delay. I’m comparing “Issues Closed during Sprint” vs “resolved date”.
When looking for the resolved date of issues (cards) I can see the actual date when it get the “Done” status, but if I try to list them, even if they are closed/done, If the “father/principal” (Task or Story) is open EazyBI count them (as closed) on the spring they fell.
I hope I could explain myself…

I’m getting the Stories and their Sub-Tasks via:
([Measures].[Cerrado en Sprint],
[Issue Type].[Story]
)+
Sum(
Filter(
Descendants(
[Issue].CurrentMember, [Issue].[Issue]),
IsEmpty([Issue].CurrentHierarchyMember.get(‘Sub-task keys’))
–and [Issue].CurrentMember.Parent.Level.Name = “Story”
and ([Issue Type].[Issue Type].getMemberNameByKey(
[Issue].[Issue].GetmemberByKey(
[Issue].CurrentHierarchyMember.Get(‘Parent issue key’)).get(‘Issue type ID’)
) = ‘Story’)

   --and [Issue].CurrentMember.Parent.Get('Issue Type') = "story"
),

[Measures].[Cerrado en Sprint]
)

)

where CERRADO EN SPRINT:

Sum(
Filter(
DescendantsSet(
[Issue.Sub-task].CurrentHierarchyMember,
[Issue.Sub-task].[Sub-task]
),
DateBetween(
[Measures].[Sub-tasks closed],
[Sprint].CurrentHierarchyMember.Get(‘Start date’),
[Sprint].CurrentHierarchyMember.Get(‘End date’)
)
),
[Measures].[Story Points closed]
)
+
SUM(
{
[Time].Currenthierarchy.Levels(‘Day’).DateMember(
DateAddDays([Sprint].CurrentMember.get(‘Start date’),1))
:
[Time].Currenthierarchy.Levels(‘Day’).DateMember(
TimeStampToDate(IIF(isEmpty([Sprint].CurrentMember.get(‘Complete date’)),
DateToTimeStamp([Sprint].CurrentMember.get(‘End date’)),
DateToTimeStamp([Sprint].CurrentMember.get(‘Complete date’)))))
},
([Measures].[Story Points closed],
[Sprint].DefaultMember)
)

(
[Measures].[Story Points closed],
[Status].[Canceled]
)