Hi! I am trying to build out a bar chart with a line graph showing development velocity over several sprint cycles for 50+ products. Sample data is below:
Product
Issue Type
Sprint 1
Sprint 2
Sprint 3
Sprint 4
Product A
Story
9
18
11
1
Product B
Story
0
0
0
0
Product A
Task
11
15
17
12
Product B
Task
0
0
38
4
Product A
Story Points
88
118
110
39
Product B
Story Points
0
0
114
12
I have built out my bar chart showing total stories and tasks completed for each sprint. I want to also include a line graph showing cumulative total story points completed for all of the sprints. I have tried different variations of rangesum and cannot get the formula to work. Any help or suggestions appreciated!
I am actually looking for a line graph of the third issue type (story points) to show cumulative story points completed for each sprint. The current expression that I have is:
