You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
We're on Cloud and use the Jira Plugin for Excel to dump sprint data and convert into several different types of reports that Jira does not offer (unless you pay for another plugin).
So because the sprint data constantly changes, I need to store the initial amount of Story-points my sprint starts with, which is equivalent to the sum of the Story-point fields from all the tickets my sprint starts with (remember tickets can change later so can the amount of points).
The problem is that there's not an easy way to calculate that number nor Atlassian makes that info available out-of-the-box (even though it's available somewhere since it shows on the sprint report in Jira).
Also, even if I was able to figure out the number of points, I'd still have to find a way to store that information in Jira... I'd assume Jira won't let me set a custom property to the sprint entity, am I correct? In that case, I'd probably have to create a custom field or something along those lines...
Has anybody had to solve the same problem before? Or any thoughts on how to solve this?