I want to calculate the average number of story points completed per assignee per sprint. For example, in sprint 1 there were 6 assignees (team members) and the team completed 70 story points. With simple math I would simply do:
70 / 6 = 11.66
However, I don’t want to create hardcoded references because I want this chart to scale with our team, so I would like EazyBI to count the number of assignees who resolved issues which had story points within a sprint and then divide the sum of completed story points by the number of assignees. I should mention that I want to calculate this for every sprint and show this trended over time.
If we need to define “Team” I’d like to define a team as a group of assignees who completed points within a sprint. This could change from sprint to sprint.
Been beating my head against a wall for a several hours and decided it was time I call in the pros. Thanks!