Cumulative Story Points committed Vs Cumulative Story Points resolved

Questions & Answers
1

Hi,

I have to create chart as Cumulative Story Points committed Vs Cumulative Story Points resolved between time line with multiple sprints(closed, opened and future sprints).

how to create this chart, I am new to eazyBi charts

I sent email to eazyBi support but no response :frowning:

Thanks,
Prasad

2

Hi Prasad,

As I recall we had an online call yesterday about this request so I assume ā€œNo responseā€ is somewhat too harsh.
Note that eazyBI support team has SLA to handle incoming questions.

Anyway, you could try using the following code to calculate Story Points (for multiple sprints) Committed

  Sum(
      Filter(Distinct(
          {[Sprint].CurrentHierarchyMember,
           CascadingChildrenSet([Sprint].CurrentHierarchyMember),
           Descendants([Sprint].CurrentHierarchyMember)}),
        NOT isempty([Sprint].CurrentHierarchyMember.get('Start date'))
        AND
        ([Measures].[Issues created],
          [Time].CurrentHierarchy.DefaultMember) > 0),
      [Measures].[Sprint Story Points committed]
    )

And for ā€œCumulative story points resolvedā€ there is a default measure in ā€œMeasuresā€ dimension already that you could use.

Best regards,
Martins / eazyBI Team.

3

Hi Martins,

I sent couple of emails before I contact you and I didā€™t got any response due to this I mentioned no response.

thanks a lot for setup a call and helping offline to create a chart!

Thanks,
Prasad