nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create EazyBI Report to show last 5 closed sprints

Erick Grimmer3

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

Accepted answers

Martins Vanags_eazyBI

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

All comments

Martins Vanags_eazyBI

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 Grimmer3

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

Josh Costella

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

Martins Vanags_eazyBI

Hi Josh,

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

Martins / eazyBI support

Cindy_chmpmz

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

Martins Vanags_eazyBI

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

eazybi