You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.