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.
My report is not restricting to the previous 8 sprints when using this code
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.