Create EazyBI Report to show last 5 closed sprints

[Erick Grimmer]

I have developed a "Closed Sprints Trend Line Graph" using EazyBI. As time goes on and more sprints are closed it would be ideal to only have it show the last 5 completed sprints without having to manually update the graph. 

How can I identify and display the last 5 closed sprints in Jira? I assume it will be use what is called a calculated member in EazyBI. Does anybody have experience in building a calculated member for this purpose?

SprintTrends.JPG ‏83 KB

[Mārtiņš Vanags · Accepted solution]

Hi Erick,

Yes, you could achieve that by creating new calculated member for "Sprint" dimension using this code example. It would create member "Last 5 closed sprints" that you could use in your reports.

Aggregate({
  Tail(Order(
    Filter([Sprint].[Sprint].Members,
      [Measures].[Sprint Closed?] = 'Yes' AND
      NOT isEmpty([Measures].[Sprint End Date])),
    [Sprint].CurrentMember.get('End date'), BASC
  ), 5)
})

Please contact support@eazybi.com if you have further questions regarding this!

Kind regards,

Martins Vanags

[Erick Grimmer]

Thank you very much, this did exactly what I needed.