I want to count the number of sprints an issue has been assigned to

Question

I am interested in building a Structure that shows how many sprints an issue has been assigned to.  (closed or open)

I see that Sprint is supposed to be a list but I cannot figure out how to count the number of sprints that each issue has been assigned to.

This worked:  sprint.size()

Dave Mitchell_uar6to · Answer

If you export issues of interest (to Excel CSV) from a query/filter (like  "...AND resolutiondate >= 2024-12-31 AND resolution is not Empty..."), and then you open Excel to view the data, you will see that in the export, there will be X columns called "Sprint" where X is the number of sprints of the "most-sprinted" issue in the export.

So then, simply use a "=CountA(range)" formula in a new column in every row of the data, and THAT cell will show the number-of-sprints for each row (ie. each issue in the export), where "range" is the cell references for the "sprint" column (like 5 sprints might be for your data) "=COUNTA(F2:H2)" in row 2, and "=COUNTA(F3:H3)" in row 3, etc.

Then I use the Excel free Analysis Pak add-in to quickly get Histogram and other information.... You can also correlate to "Points" to help struggling teams see what they are (or are not) doing....

Sean Saxon_g4wpm5 · Answer

The provided link was not useful, and I remain unconvinced that the original poster's question was addressed.

Mykenna Cepek · Answer

Sounds like you are using Jira Automation?

And you figured it out?

For those playing along at home, the documentation is here:

https://confluence.atlassian.com/automation/jira-smart-values-lists-993924868.html