Cumulative Story Points committed Vs Cumulative Story Points resolved

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

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.

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