Average completed story points, broadcast in slack

[Chris Carpenter]

Hey folks

Getting a bit of automation together that will broadcast some stats in a slack channel when a sprint is closed out. Going well so far, been learning a lot about what you can accomplish with smart values. I am stuck on one of the data points though.

I would like to have the average number of story points we have completed across our past sprints be a part of this. Specifically im having trouble figuring out to get those completed story point values so I can take the average from them.

Anyone know if this is possible, and if so, any idea how to do it?

Thanks in advance!

[Bill Sheboy]

Hi @Chris Carpenter 

If you can write a JQL statement for the issues you care about, you could use the Lookup Issues action, and then average the story points (or story point estimate for a team-managed project):

{{lookupIssues.Story Points.average}}

Please look here for more information:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-general/#Smartvaluesgeneral---lookupIssues--

Best regards,
Bill