Skip to main content

The chart editor, as a recipe

The chart editor used to speak the engine's language — X-axis, Y-axis, Color By, CDistinct, Count of Records — and it only took the fields you dragged from a long list of tables. It now reads as a short recipe you complete — Show a measure, Per a breakdown, Split by a category — with the chart beside it, drawn as you go.

A recipe, in plain words​

The editor's left column lists the chart's steps in the order you would say them: Show, Per, Split by, Only, Sort & limit, Appearance. Each chart type uses its own words: a pie shows the Share of something, a histogram the Distribution of a number, cut In so many bins, a funnel counts At each stage, a Sankey follows a Flow of something From one field To the next, and a map colors By region. Count of Records is now Number of orders (or whatever the table holds), CDistinct is Unique count, and the shared time axis is simply Date.

Click where you used to drag​

Every step opens a short list of what fits there, with a search box. Your company's metrics come first when you pick a measure; once one is picked, the breakdown list leads with dates when the measure has one, and folds away the fields that can't be combined with it. The rows of that list can still be dragged onto a step or straight onto the chart. On the chart itself, the axes are chips: click one to swap its field. Need a field that doesn't exist yet? New calculation…, at the foot of the measure list, writes it and puts it on the chart.

A place to start​

A new chart opens on a question — What do you want to see? — and up to four charts drawn from your data: your company's metrics over time, by category, on a map, and a count. One click fills the recipe. The chart type follows your first picks (a line for a date, a map for a place), then stays yours. The lists learn from your team too: fields charted with your measure elsewhere, then the most used ones, come first, each with a short note saying why; your latest picks sit on top under Recent, and columns that look like identifiers fold away.

Every field, when you want it​

The lists behind the steps show only what fits. When you'd rather see everything — a new dataset, a field you can't place — Browse all fields opens the whole list beside the recipe: by role or by table, searched by name, table or description, with what can't be combined with your chart set aside. Click a field and it lands where it fits, never replacing anything; hover it to choose the step yourself, or open its details first: its description, a few of its values, how many charts use it and what it's charted with most.

Filters, order and look, each in its own step​

Only lists the chart's conditions in words — France, except gift card, order value above 1,000 — and adding one takes two picks: the field, then its values. Each condition opens on the natural question for its field — values to tick, a number to stay above, a period that applies as soon as you pick it, Yes or No in one click — and says how it compares in words, with the usual symbols beside them. Or another condition… adds an alternative, and the tab's filters sit underneath, each with a checkbox to follow it or not. The filter pills on the dashboard open the same editor. Sort & limit reads the order and the top N back in one line. Appearance is one short list per chart type — titles, number formats, line shapes, reference lines — and colors sit on the rows they paint: a swatch on each measure, one per value on a split, a pie's slices or a Sankey's stages. A second measure shares the value axis when both are measured the same way, two amounts in euros, say, and takes the right axis otherwise.

The chart reads back​

The header carries the chart's title, editable in place, and a line that says what the chart shows: Total revenue · per month · split by sales channel · France only · this year (tab). The chart type is a strip of eight glyphs beside it. The SQL, the data map, a reset and a change of data source moved to a ⋯ menu; changing the source clears the chart, so Axiome asks first.

📖 Charts · Start from a suggestion · Set up the data · Browse all fields · Filter · Appearance · Tab filters