Looking for help with a calculated member to solve this problem.
In our Jira project issues have a custom field called Story points, and each issue is assigned to one or more sprints. I want to create a report that, for each sprint, calculates the sum of story points for all issues that are assigned to that sprint as their latest sprint.
For example, if issue X is assigned to sprint 1, 2 and 3, I want the story points from issue X to be added to the cell for sprint 3 only. If issue Y is assigned to sprint 2, 3 and 4, I want the story points from issue Y to be added to the cell for sprint 4 only. Etc.
Sprints can be ordered by their start or end date. If a sprint doesn’t have dates yet, it’s in the future. The report does only need to show closed or active sprints.
What should the code for such a calculated member look like?