Issues Burndown for specific status

Questions & Answers
1

Hello!

I’m trying to create a board in Eazy Está BI that gives me a view of burndown and burnup like the one presented here:

Sprint burn-down or burn-up chart

But I need the issue’s done criteria to be a certain status on my board, not the status of done, as is the default.

Is it possible to do this? What should I change in what is presented in the example to achieve this?

As the activities in my project only end on the last day of the sprint, we would like to have a burndown view considering a step before the Product Owner’s approval.

2

Hello @LeoGregorio ,
You can modify the standard burndown chart to track a specific status by using this formula for your Story Points measure:

Sum(
  Filter(
    DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    DateInPeriod(
    ([Measures].[Transition to status last date],
    [Transition Status].[Your Status Name],
    [Time].CurrentHierarchy.DefaultMember),
    [Time].CurrentHierarchyMember)
  ),
  [Measures].[Story Points history]
)

Replace “Your Status Name” with the status you want to track. In other measures, replace “Story points resolved” with your newly created measure.

Kindly,
Gerda // support@eazybi.com