Calculate Velocity for last 5 Sprint but limit to specific Issue Types using a user defined calculate measure

Questions & Answers
,
1

I would like to copy the “Running Story Points Velocity for 5 closed Sprints” OOTB measure and modify to calculate Velocity for the last 5 Sprints. See code below.
In my bar chart, I include the Issue Types: Story, Support Issue and Bug for various reasons.
How can I modify the code below to limit the Velocity calculation to only Story and Support Issue.
I need to keep Bug in the overall Bar Chart data display.

Current bar chart is below where the dashed line is velocity in which I need to remove the Bug component.

CASE
  WHEN
    [Sprint].CurrentHierarchyMember.Level.Name = 'Sprint' AND
    [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
  THEN
  AVG(
    Tail(
      Filter(
        -- filter last 5 previous sprints in a board starting from current sprint
        [Sprint].CurrentHierarchyMember.FirstSibling:
        [Sprint].CurrentHierarchyMember,
        [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
      ),
      -- set the count of last closed sprints for running velocity
      5 ) ,
    [Measures].[Sprint Story Points completed]
  )
END

Bar Chart
Bar Chart1603×630 36.1 KB

2

Hi,

You can use the tuple to count the completed story points or specific issue types:

CASE
  WHEN
    [Sprint].CurrentHierarchyMember.Level.Name = 'Sprint' AND
    [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
  THEN
  AVG(
    Tail(
      Filter(
        -- filter last 5 previous sprints in a board starting from current sprint
        [Sprint].CurrentHierarchyMember.FirstSibling:
        [Sprint].CurrentHierarchyMember,
        [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
      ),
      -- set the count of last closed sprints for running velocity
      5 ) ,
    ([Measures].[Sprint Story Points completed],[Issue Type].[Story])+
    ([Measures].[Sprint Story Points completed],[Issue Type].[Support Issue])
  )
END

Kindly,
Janis, eazyBI support

3

That did it, thank you so much for your help!