I have a table named "UX data", There is "issue type" field which consist of different issues in which "story" is one of the issue, "status" field which consist of different status in which "Closed" is one of them, there is "Sprint ID" field as well.
Now there are total 843 issues, out of which 288 are issue type=stories and in that 288 stories, 140 of the stories are having status=closed.
Now I need to plot burndown graph for this. There are different sprints ie sprint 1,2 etc,... there are many issues but i only want stories burnt.
Now total stories for each sprint are, blank(no sprint id)=73 stories, sprint 1=54,sprint 2=44,sprint 3=47,sprint 4=34,sprint 5=28, sprint 6=8.
Out of this, stories that are closed for each sprint are, blank(no sprint id)=6 stories, sprint 1=33,sprint 2=26,sprint 3=24,sprint 4=25,sprint 5=20, sprint 6=6.
There are total=288 stories, out of which 140 stories are closed. Now I want to subtract total stories from stories closed each sprint. i.e 288-6(stories closed-for blank)=282 and this value should be subtracted from the next value of stories closed. ie. 282-33(story closed in sprint 1=249) and next 249 should be subtracted from stories closed in next sprint and so on.
I am not able to do it.
I tried many trial and error to subtract 288 from stories closed but then it gets subtracted from 140 instead of 288. So I tried something else. I have attached a screen shot where "SB 10" is a measure which calculates stories each sprint, "SB2" measure calculates stories closed each sprint, SB 11 is SB 10 - SB2.
I created a measure named "measure 2" which calculated total stories and gave same value to each row using all selected.
Then I thought of subtracting each row of "measure 2" should get subtracted from all the previous values of SB2 sprint values and created it using "measure 3" but here each rows of measure 2 is getting subtracted from each row of sb2 i want to subtract it from all previous values of sb2.
Example: In sprint 2, measure 2=288, this should get subtracted from SB2 from their current and previous values that is sprint 1=21, blank=67 (288-21-67=249)
These are the burndown values required:282, 249, 223,199, 174,154, 148
