I despair of ever understanding how charts work.
This:
data-series-chart
conditions: 'Moved to Rolled Out In' >= (8 Weeks ago) OR ('Moved to Rolled Out In' IS NULL AND 'Moved to Staging In' >= (8 Weeks ago))
x-title: Week
y-title: Stories Built
chart-type: bar
chart-height: 500
chart-width: 600
plot-width: 500
plot-height: 375
three-d: false
conditions: 'Moved to Staging In' IS NOT NULL
labels: SELECT DISTINCT 'Moved to Staging In' ORDER BY 'Moved to Staging In'
cumulative: false
legend-max-width: 120
legend-offset: -300
series:
- label: Staged Stories
color: magenta
data: SELECT 'Moved to Staging In', COUNT(*) WHERE Type = Story
empty-columns: true
- label: Rolled Out Stories
color: green
data: SELECT 'Moved to Rolled Out In', COUNT(*) WHERE Type = Story
empty-columns: true
gives me the attached chart.
I obviously don't want to see all cards on the x-axis. Instead, I'd like to see Weeks. Only those the last 8 ones.
The equivalent stack bar chart (i.e., everything is the same, except "data-series-chart" is replaced with "stack-bar-chart") doesn't behave the same way. It only shows the weeks I want.
/files/0b761265ef/Snapshot_2011-04-05_10-04-51.jpg 584x506
Comments
1 comment
Hi Olivier,
I understand your frustration. The charts are quite flexible, so sometimes they do exactly what I want and sometimes they take a little more trial and error. The data series chart is a bit more flexible with what can be on the x-axis than the stack bar chart, so it sometimes needs a bit more information to get the x-axis set up correctly. In this case, I think you need to add a x-labels-conditions parameter which has the same value as the conditions parameter.
-Jay
Please sign in to leave a comment.