Community
Q&A
Jira
Questions
Create EazyBI Report to show last 5 closed sprints

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?

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Martins Vanags_eazyBI But what if you wanted to show Sprints in the rows and show as a bar chart? bar chart.png

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Josh,

I believe you could turn off the "Vertical" button in toolbars to show your bar chart horizontally.

Martins / eazyBI support

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Martins Vanags_eazyBI

I tried your way to display the last 5 sprints and it was successful.

But, what if I want to view last 5 sprints for specific squad in a project that consists of multiple squads?

I tried to filter the squad name using pages, but it still showing the last 5 sprints from all squads

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

Please find this community post about filtering last 5 sprints for the report context

https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099/6

Martins / eazyBI team

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

My report is not restricting to the previous 8 sprints when using this code

Screen Shot 2021-03-27 at 4.45.02 PM.png

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Cindy

we don't see the full definition of your calculated member, perhaps you could reach out to support@eazybi.com and provide more details about your use-case.

Martins / eazyBI team

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Create EazyBI Report to show last 5 closed sprints

2 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events