I despair of ever understanding how charts work.
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))
y-title: Stories Built
conditions: 'Moved to Staging In' IS NOT NULL
labels: SELECT DISTINCT 'Moved to Staging In' ORDER BY 'Moved to Staging In'
- label: Staged Stories
data: SELECT 'Moved to Staging In', COUNT(*) WHERE Type = Story
- label: Rolled Out Stories
data: SELECT 'Moved to Rolled Out In', COUNT(*) WHERE Type = Story
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.