I have been trying to find a way to do multi-team, mostly (or entirely) automated Sprint metrics for a long time now. I had a process that mostly worked for Jira Server\DC:
(sprint = "[SPRINT NAME]" or issuefunction in removedAfterSprintStart("[BOARD NAME]","[SPRINT NAME]")) and issuefunction not in addedAfterSprintStart("[BOARD NAME]","[SPRINT NAME]") and issueFunction in aggregateExpression("Total Story Points", "StorySize.sum()")
I recently joined an organization which uses Cloud, and as it turns out, some of the key functions I relied on (namely "aggregateExpression", "removedAfterSprintStart", "incompleteInSprint", and "completeInSprint") don't exist because they're not possible via the API.
I could probably muddle through without "aggregateExpression", but retrieving the initial sprint commitment is impossible without "removedAfterSprintStart". This is kind of a key metric, so not collecting it is not really an option.
Has anyone found an add-on which provides these metrics in a queriable\exportable manner? It feels like the only solution at this point would be to pull an "initial sprint commit" and perform some kind of diff analysis.
I'd like to avoid having my scrum leads need to manually read the sprint report; that report has bugs in it, but also having humans manually read a report so they can input numbers into another report is a tremendous waste of potential.