Additional Table
The Additional Table card stores the JSON-backed configuration for extra columns, edited through a dedicated dialog rather than typed by hand.
Opening the editor
- Select the visual and enter edit mode (or focus mode) with at least one measure bound to Values
- Hover the visual — a small ⚙ gear icon fades in at the top-right corner
- Click it to open the Extra Columns dialog
Fields per column (up to 8)
Each column's block has a few fields always visible, plus two collapsible sections (collapsed by default) for the settings you tune less often. Expanding/collapsing a section applies to every column's block at once — expand Significance once and it stays open while you configure the rest of your columns.
Always visible
| Field | Type | Notes |
|---|---|---|
| Column title | Text | Spans two grid cells in the dialog |
| Score type | Continuous / Discrete | Default Continuous — see Columns → Continuous vs. Discrete columns |
| Score measure | Measure picker | Required — a column with no Score is skipped entirely |
| Base | Measure picker | Optional — hidden when Score type is Discrete |
| Display | Value / Gap / Value & Gap / Comparison value / Comparison Gap / Comparison Value & Gap | Default Value — hidden when Score type is Discrete — see Columns → Display modes |
| Precision | Number (0–6) | Default 0 — hidden when Score type is Discrete |
| Show header | Checkbox | Default on |
Format (collapsible)
| Field | Type | Notes |
|---|---|---|
| Font | Font family | Default Segoe UI |
| Font size | Number (6–40) | Default 11 |
| Font color | Color | Default #333333 |
| Bold / Italic / Underline | Checkboxes | Bold on by default |
| Column width (px) | Number (30–300) | Default 76 |
| Display conversion picto | Checkbox | Default off — hidden when Score type is Discrete — see Conversion picto below |
| Separator (border) | Checkbox | Draws a vertical line on the column's right edge, spanning the funnel's step area |
| Separator color | Color | Default #cccccc |
Significance (collapsible)
| Field | Type | Notes |
|---|---|---|
| Significance level | 90% / 95% / 99% | Default 95% — hidden when Score type is Discrete — this column's own level, independent from Leakage → Significance level |
| Independence | Main separate from comparison / Main is part of comparison / Comparison is part of Main | Default Main separate from comparison — hidden when Score type is Discrete — see Leakage → Independence for what the three options mean |
| Comparison | Measure picker | Optional — hidden when Score type is Discrete |
| Comparison base | Measure picker | Optional — hidden when Score type is Discrete |
| Color above comparison | Color | Default #cc0000 — hidden when Score type is Discrete |
| Color below comparison | Color | Default #007700 — hidden when Score type is Discrete |
| Reverse test | Checkbox | Swaps above and below for this column — see Reverse test |
| Display mode | Font color / Icon / Frame / Background / Free text | Default Font color — how a significant cell is flagged, see Significance display |
| Custom icon above / below (base64) | Text | Icon mode only — a data:image/…;base64,… image; empty = the default triangle tinted with the column's color |
| Text above / below | Text | Free text mode only — default + / -; any characters or emoji, empty = no symbol |
| Add to legend | Checkbox | Adds this column's significance to the legend |
| Legend label | Text | When Add to legend is on — one label for both directions, default "Significantly higher / lower" |
Click Add column to append a new one (up to 8 total); an empty state ("No extra columns yet — click Add column.") is shown when none exist yet.
Switching a column's Score type between Continuous and Discrete immediately shows/hides the fields that only make sense for one of the two — no need to save and reopen the dialog. Existing columns saved before this setting existed default to Continuous, so nothing changes for reports created earlier.
Reverse test
The test compares the column's Score with its Comparison: above means Score is significantly higher than Comparison. When the displayed figure is read from the other side, that wording is backwards. Typical case: Score = the N-1 average, Comparison = the current year N, display = Gap. A Gap of -2.8 means N is below N-1 — yet the test says N-1 is significantly above N, so the cell would read "significantly higher" next to a negative number, with an arrow pointing the wrong way.
Checking Reverse test swaps the two directions for this column only: Score significantly higher than Comparison is shown as below, and lower as above. Colors, icons, frames, texts and the legend all follow, so the sign, the arrow and the wording agree. The test itself (z value, level, independence) is unchanged.
Significance display
A cell is flagged only when its test is significant (above or below the Comparison); neutral cells stay untouched. The Display mode picks how, using the column's Color above / below comparison:
| Mode | Result |
|---|---|
| Font color (default) | The value is written in the above/below color |
| Icon | A triangle (▲ above, ▼ below) tinted with the color — or your own base64 image — right after the value |
| Frame | A colored border around the cell |
| Background | A light tint of the color behind the cell |
| Free text | Characters of your choice (+, -, a letter, an emoji) in the color, right after the value |
With any mode other than Font color, the value itself keeps the column's font color.
Add to legend gives the column one legend entry: a sample number (123) shown with the above decoration then with the below one, followed by the Legend label prefixed with the column title (e.g. "Gap vs average — Significantly higher / lower"). The entry appears in the legend below the funnel whether or not the leakage pills or the Leakage legend are on, as long as the column actually runs a significance test.
Conversion picto
When Display conversion picto is on, a small arrow glyph is drawn just in front of (to the left of) the column's value at every step, colored by that step's column-level significance test against its Comparison.
| Test result | Picto color |
|---|---|
| Significantly above the Comparison | Color above comparison (default #cc0000) |
| Significantly below the Comparison | Color below comparison (default #007700) |
| Neutral, or not tested (Base / Comparison / Comparison base not all set) | Gray (#888888) |
- The picto's horizontal space is reserved for the whole column as soon as the option is on, so figures stay aligned from row to row.
- Doesn't apply to Discrete columns, which have no significance test to react to.
Behind the scenes
The dialog persists its entries as a single JSON array in the Columns (JSON) property of the Additional Table card. Clearing all columns and saving leaves an empty array — the funnel simply renders with no extra columns.