Create EazyBI Report to show last 5 closed sprints

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?

1 answer

1 accepted

1 vote
Accepted answer

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,152 views 5 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you