Skip to content

Bars, stacked

Chart

The series in each slot are stacked into one column, so its height is their total.

The series are parts of one whole and both the total and its make-up matter — tickets per day split by channel. Show it as share to compare the mix instead of the amounts.

The series overlap or nest (a funnel’s steps): the stack would total to a number that means nothing.

A column to put along the bottom — a date for a trend, or a category (a status, a person, a town). A sum or an average also needs a number column.

Describe it in a sentence — for example “tickets per day by channel”.

An assistant connected to Routario over MCP (Claude, ChatGPT) makes it with chart_create, then puts it on a board with dashboard_tile_add.

  • Show as — On a stacked chart: the amounts themselves, or each part’s share of its own bar, so every bar reaches 100%.
  • Subtitle — One line under the title. What the reader should take from it.
  • Along the bottom — The column whose values become the slots along the bottom — a date for a trend, a category for a comparison.
  • Grouped by — Only applies when the column along the bottom is a date: which stretch of time each slot covers.
  • Series — Each series is one measure, optionally narrowed to the rows that match a condition.
  • Measure — What each series computes over the rows in a slot.
  • Unit — For ‘time between two dates’: the unit the gap is measured in.
  • Aggregate — For ‘time between two dates’: how several rows’ gaps become one number.
  • Where — Narrows one series to the rows matching a condition — how several series share one axis.
  • Colour — A plain colour picks a pigment and says nothing about the data. A named meaning — went well, needs attention, went wrong — tells the reader something they will believe.
  • Show numbers as — How the value axis, the tooltips and the printed values spell a number.
  • Show dates as — Only applies to a date axis; anything else is left exactly as stored.
  • Draw a line between the slots — A faint line at each boundary between two slots along the bottom, so every mark reads against its own label. On by default for a range, off for bars.
  • Targets — A flat line at a goal, a floor or an SLA the chart is judged against. Not something the data produced.
  • Good side of the target — Which side of the target is good — it colours how far a number is from it.
  • Legend — Where the series names sit, if anywhere.
  • Value axis — Whether the numbers up the side are drawn. On unless switched off.
  • Labels along the axis — Whether the slot names along the bottom are drawn. On unless switched off.
  • Gridlines — Whether the faint lines across the plot at each value step are drawn. On unless switched off.
  • Title under the axis — A title under the labels along the bottom, up to 60 characters.

Auto-generated from the tile registry (core/custom_tables/tile_registry.py) — the same text the chart editor and the AI drafter read. Do not edit by hand.