With some help, I managed to get a nice data-series chart that gives me an idea of release quality over time, showing number of story points in the release vs # of defects logged against it.
After looking at it, I realized that it was a bit hard to interpret, because the key thing was the relationship between the lines. If points is way above defects, great. If it's at or under, not so good. So what I really want to graph is the ratio of the two, and get that trendline.
What I've got is a Release tree that looks like Release->Release Patch->Story, and in MQL I basically want:
Patched defects for a release: select count(*) where type=Story and 'Release Patch' is not null
Release total points: select sum(Estimate) where type=Story and 'Release Patch' is null
I've got both of these as aggregate properties on the Release card, and created a function property which is points/defects. This shows up nicely on the Release card, can be added to views as a column. But when I tried to graph it using the data-series definition below, all the values are 0. I also tried graphing some other tree aggregate proeprties, and no dice there either.
Also, not sure if this is a clue of what's going on, but the y-axis goes up to a value of 120. The values of this metric are < 10, so I was a bit surprised to see the y-axis go so much higher.
Is there a way to graph this number that I've calculated?
conditions: type = 'Release'
x-labels-conditions: NUMBER > 7000
- data: SELECT Release, SUM('Release quality')