Eazybi Measure : Name of latest sprint

Question

Hi,

Jira issues can be assigned to multiple sprints. I want to create a measure that shows the latest sprint an issue has been assigned to.

The sprints are displayed in the "Issue Sprints" measure.

I was thinking of just getting the last value in the list. Or maybe getting the sprint with the hightest ID (assuming that is the one created last).

I don't care if the sprint is active, in progress or closed. And since not all sprints have a start- or end date, i also can not use that to determine the last one.

Any idea's on how to get the last values in the sprints list?

Thank you and best regards,

Kris

Kris Dewachter · Answer

Hi @Gerda Grantiņa _ eazyBI ,

After some more investigation, it seems like this was only going to work with creating a new custom field via the Jira import, and extracting the sprint value via Javascript.

So i created this, and this seems to return the value i need.

Best regards,

Kris

Kris Dewachter · Answer

Hi @Gerda Grantiņa _ eazyBI ,

Thank you for your assistance.

Unfortunately, the "Issue Sprint" measure is mostly remaining empty, even when the "Issue Sprints" value contain multiple sprints.

Based on the records that actually have a value, it's my understanding the "Issue Sprint" only contains active sprints.

So for example, for the last line in my screenshot, "Issue Sprint" is empty because "Sprint 3" and "Sprint 4" are closed and no longer active.

As stated, I want to display the last sprint, regardless of it's status, start- or end-dates.

Would it be possible to extract that from the "Issue Sprints" field (ex. last value in the list) ?

Best regards,

Kris

Gerda Grantiņa _ eazyBI · Answer

Hello @Kris Dewachter ,

Instead of trying to extract the latest sprint from the "Issue Sprints" list, I would recommend using the "Issue Sprint" property (singular form). This property shows the current sprint to which an issue is assigned, which is effectively the latest sprint.

Using "Issue Sprint" will give you the information you need without having to create any complex measures or formulas to parse the full sprint list.

Kindly,

Gerda // support@eazybi.com