Count issues without story points in sprint at closing (without subtasks and Spikes)

Questions & Answers
1

Hi everyone,

I’m trying to build a report that shows how many issues there were in a sprint without SP at closing, not counting the sub-tasks and spikes. Could anyone help me define a measure for such a report?

Thanks in advance,
Zalina

2

Hi @Zalina_Kaytmazova,

eazyBI offers a measure to show which issues were in Sprint at closing, “Sprint issues at closing”, and also a measure showing how many story points were in Sprint at closing, “Sprint Story Points at closing”. To get the combined view of how many issues were without Stroy points, yuo should create a new calcauted measures.
The calcaution would iterate through all issues that were in Sprint at closing and check their Story Point value on that date.

Sum(
  --set of issues
  Filter(
    --iterate through Parent issues that have been in some sprint
    Descendants([Issue.Sub-task].CurrentHierarchyMember,[Issue.Sub-task].[Parent]),
    CoalesceEmpty([Measures].[Issue Sprints],"") MATCHES
      ".*" || [Sprint].CurrentHierarchyMember.GetCaption || ".*"
  ),
  CASE WHEN --issue was in Sprint at Closing but had no SP
    [Measures].[Sprint issues at closing] > 0 AND
    IsEmpty([Measures].[Sprint Story Points at closing])
  THEN --count parent issue 
    1
  END 
)

More details on calculated measures and used MDX functions are described here:

Best,
Zane / support@eazyBI.com

3

Hi Zane!

Thank you so much for you help.
For some reason this measure does not return any results, what could be the issue? I added Project and Sprints in the rows, maybe something else is missing?

Kind regards,
Zalina

4

The calcaution is designed to work when individual Sprints are on report rows and compares the selected sprint name on report rows with the sprint names for each issue.

If you use vacated members in the Sprint dimension or board level, then you might use a more universal expression:

Sum(
  --set of issues
  Filter(
    --iterate through Parent issues except for Sub-tasks
    Descendants([Issue.Sub-task].CurrentHierarchyMember,[Issue.Sub-task].[Parent]),
    [Measures].[Issue type] NOT MATCHES "Sub-task"
  ),
  CASE WHEN --issue was in Sprint at Closing but had no SP
    [Measures].[Sprint issues at closing] > 0 AND
    IsEmpty([Measures].[Sprint Story Points at closing])
  THEN --count parent issue 
    1
  END 
)

Let me know how this works for you.
Kind regards,