Report for multiple project teams with weekly sprints

Questions & Answers
1

Hi,

I am looking at creating a consolidated sprint overview report for multiple projects.

  • The report should reflect the data as below

13%20PM

  • Breaking down the sprints based on points for each issue type as well.

Need help creating these filters and consolidation. Please advice.

2

Hi @Shoba_Cardoza,

You could try to create a similar report by moving the Measures dimension to the rows and the Sprint dimension to the columns. To display the total of completed story points, use the measure “Story points completed”. For the “Total Assignees” you could try to use the calculation below:

Count(
   Filter([Assignee].Members,
   [Measures].[Sprint Story Points completed] >= 0)
)

To see the information relevant to the Project dimension members, please try the “Drill across” functionality.

Kind regards,
Robert // eazyBI support