Max completion sprint at capability level

Hi,
I am trying to graphically visualize the “final” or “max” sprint for a series of capabilities. The idea is to show at what sprint each capability is completed. In Jira, I broke down each capability into its designated features and extracted the max sprint of each of these features and added a column which then shows when their capability is completed according to the latest completed feature. Now I need to visualize this in EazyBI. My first question is: Is this even possible to be done on EazyBI? And if yes, how do I go about this? My assumption is that I am choosing the wrong type of measure, but I cannot seem to figure out which fields I can choose to do that.

Hello @PastaFasta,

Thank you for posting your question & welcome to the eazyBI community!

From what you’ve explained, generating the report you need seems possible in eazyBI. You will need to create a new calculated measure. Here is how to create it: Calculated measures

You can use the following function for your calculated measure. It will show the last Sprint in which an Issue was completed.

Tail(
Filter(
  [Sprint].[Sprint].Members,
  [Measures].[Sprint issues completed]>0
)).Item(0).Name

In my example below, I am using a standard Epic hierarchy under “Issues” dimension and the newly created measure “Final Sprint”.
You can see different Issue types and which was the last Sprint they were completed in.

To successfully use this example, you will need to make sure that you have a hierarchy where a Capability is linked with a Feature.

You can read more about custom hierarchies in our documentation here: Additional Issue hierarchies

I hope this helps, but let us know if you have any further questions.

Best,
Marita from support@eazybi.com