Summary
Add a stacked bar chart option to notebooks for comparing a value broken down into named components across several categorical groups (e.g. "budget breakdown per item, compared across N items"). A colleague shared a mockup from another tool as reference; the shape is a grouped/stacked bar chart with:
- One bar per category on the x-axis
- Each bar stacked from several named series (a fixed, shared legend across all bars)
- Per-segment value labels drawn inside each stack segment when it's tall enough
- A "Normalize" toggle that switches the whole chart between absolute values (stacked to the raw total) and 100%-stacked percentages
- A side legend mapping series name → color, shared across bars
Why
The existing Chart cell supports line/bar with per-row SQL-driven colors, but bars there are one value per x position — there's no support for stacking multiple named series into a single categorical bar, and no normalize-to-percentage toggle. The Pie Chart cell covers proportional breakdown for a single category but not side-by-side comparison across multiple categories.
This would be useful for any "breakdown of X across several things" comparison — e.g. time spent per phase across several test scenarios, resource usage per component across several builds, etc.
Rough shape
- New cell type (or a
stacked mode on the existing Chart cell) taking a SQL query with category, series, and value columns (long/tidy format), similar in spirit to the Chart cell's query definition
options.normalize (boolean) or a UI toggle to switch between absolute and 100%-stacked views- Legend and per-segment coloring consistent with the existing Chart/Pie Chart palette conventions
Happy to help refine the exact SQL column contract if useful — filing this mainly to capture the request.
Summary
Add a stacked bar chart option to notebooks for comparing a value broken down into named components across several categorical groups (e.g. "budget breakdown per item, compared across N items"). A colleague shared a mockup from another tool as reference; the shape is a grouped/stacked bar chart with:
Why
The existing Chart cell supports line/bar with per-row SQL-driven colors, but bars there are one value per x position — there's no support for stacking multiple named series into a single categorical bar, and no normalize-to-percentage toggle. The Pie Chart cell covers proportional breakdown for a single category but not side-by-side comparison across multiple categories.
This would be useful for any "breakdown of X across several things" comparison — e.g. time spent per phase across several test scenarios, resource usage per component across several builds, etc.
Rough shape
stackedmode on the existing Chart cell) taking a SQL query with category, series, and value columns (long/tidy format), similar in spirit to the Chart cell's query definitionoptions.normalize(boolean) or a UI toggle to switch between absolute and 100%-stacked viewsHappy to help refine the exact SQL column contract if useful — filing this mainly to capture the request.