Displaying Active Burndown by Project

Hi!

I am interested in creating a burndown that displays most recently started sprint in every project we have imported, automatically. (So we can have a dashboard showing all of the various project’s burndown reports). So far, I can capture all the active sprints, but I can’t seem to get it to automatically select the most recent one in the project, even if I filter it by the most recently created date, and select the first most value.

Thanks for the help!

To clarify, I mean a Sprint Burndown.

Hi,

Sorry for the late response.

The solution to show the measures on the last sprints related to the projects can be implemented only by adjusting the measures. You could use the Project dimension in the report for your burndown chart and adjust measures to give results related to the most recently created sprint. Please, find here an example of how to get the Issues created for the last sprint which is related to the project:

nonzero((
  Order(
    Filter(Descendants([Sprint].CurrentHierarchyMember,[Sprint].[Sprint]),
      ([Measures].[Issues created]>0 AND
      [Sprint].CurrenthierarchyMember.Name <> "(no sprint)"
    )),
    [Measures].[Sprint start date],
    BDESC
    ).item(0),
  [Measures].[Issues created] -- specify your measure here
))

Kindly,
Janis, eazyBI support