I'm trying to work on a data-series chart that shows past releases, and how many patches they required as well as how many patch-worthy defects were reported on them, as a metric of ongoing quality of releases.
I'm having some trouble with the x-labels-start property though. We average a release every two weeks to one month, and so there's a LOT of elements in the x axis. I'd like to start the axis at a particular release, but can't figure out how to identify a particular release as 'the one' to start with. I thought that using the card ID, perhaps with NUMBER before it, would do it, but apparently not. Can someone point me in the right direction?
I've attached the data series that I'm trying below.
Code Snippet
data-series-chart
conditions: type = 'Release Patch'
cumulative: false
x-labels-start: NUMBER 5115
series:
- data: SELECT Release, COUNT(*)
label: Patches per Release
color: #FF0000
trend: true
trend-line-width: 2
Comments
5 comments
Chris, do you have a property on Release Patch card such as release number? If so you could do something like
{{
data-series-chart
conditions: type = 'Release Patch' AND 'Release number' >'5115' AND 'Release number' <'5200'
cumulative: false
Hi Ian,
Thanks for the tip. To answer your question, there is a Releases tree that has Release as a parent to Release Patch. I tried your suggestion, and it didn't parse, but the slightly different one:
type = 'Release Patch' AND 'Release' > 5115
does parse. But it seems it returns EVERYTHING. I tried upping the limit so only a few releases would be in there, but no luck.
Hi Chris,
OK, I think I see that you are trying to test using the name of the release card, which i think only works in a Select Where... IN (name1,name2), and not in the chart conditions. i have a simialr chart using story /reelase relatiionships and i restrict reelase by the release property 'start date'. do you have any properties on the reelase card tha tyou can use like this, or perhaps add something?
{{
data-series-chart
conditions: 'Type' = 'Story' And 'Story Status' != Open AND 'Story Status' != Deleted
x-title: Release
y-title: no of stories
x-labels-conditions: Type = Release and 'Start date' >'01/07/2010'
cumulative: false
plot-x-offset: 90
chart-height: 400
chart-width: 500
legend-max-width: 200
chart-type: bar
series:
- label: no of stories/release
color: darkgreen
data: SELECT 'Release', count(*) WHERE Type = Story and 'Story Status' != Open and 'Story Status' != Deleted
- label: no of Completed stories
color: purple
data: SELECT 'Release', count(*) WHERE Type = Story and 'Story Status' = 'Awaiting sign off' OR 'Story Status' = 'Accepted'
}}
Ah, that did it! I do have a 'Proposed release date' field, but I was able to use the form NUMBER > 7000 as well.
Hopefully you won't mind one more question. The sorting of the items in the x-axis seems to be alphabetical by card name. Is there a way to do it by some other property, or do I need to rename all my releases?
Chris,
I'm afraid I just named the cards to be sorted alphabetically so i have not looked at sorting in any detail. However looking at the macro help for charts i think you could use another property to sort by, but it would be displayed instead of the release number, which i don't think is what you want
Please sign in to leave a comment.