Range Column Flow

This flow covers Range Column Series, the single chart type used for min-max range display. Each data point contains a Low (lower) and High (upper) value; the bar renders between these two values. The flow skips Step 5 Series Design and Step 6 Add Series — Low/High mapping is done directly in Step 4.

Chart Types Using This Flow

Chart Type	Primary Use	Page
Range Column Series	Min-max range bar (temperature band, pressure range)	Range Column

Single Chart, Special Flow

Range Column is a single chart type but its wizard flow differs significantly from standard Cartesian: instead of a single Y column, the Y axis maps to a Low / High pair, an optional categorical Color By column can be selected, and series design is not performed.

---

Flow Diagram

flowchart LR
    A[1. Group<br/>Cartesian] --> B[2. Chart Type<br/>Range Column]
    B --> C[3. Compass Record]
    C --> D[4. Axis Config<br/>+ Low/High + Color By]
    D --> G[7. General Design]
    G --> H[8. Card Design]
    H --> I[9. Display]

---

Step Pages

This flow runs 7 of the wizard steps (5 and 6 are not present):

#	Step	Page	Key Content
1	Group Selection	01 — Group Selection	Select the Cartesian card
2	Chart Type Selection	02 — Chart Type	Range Column card
3	Compass Record Selection	03 — Compass Record	Query must return low + high columns
4	Axis Config + Low/High	04 — Axis Config + Low/High	X axis, Low/High Value, optional Color By + Assign Colors
7	General Design	07 — General Design	Title, Legend, Axis (Y axis range matters)
8	Card Design	08 — Card Design	Refresh, Border, Info Card
9	Display Information	09 — Display	Name, Tags, Folder

Steps Not in This Flow

Skipped Step	Purpose in the standard flow	Why it isn't needed here
5 — Series Design	Series color, marker, and data label visual settings	Color assignment for Low/High and optional Color By categories is done in Step 4; there is no separate series design step
6 — Add Series	Add a second/third series to the chart	Range Column uses a single range series; multiple series are not supported

---

Data Requirements

Columns the Range Column record must return:

Column	Type	Role	Required
X column	TIMESTAMP / TEXT	Axis labels	✓
Low Value column	NUMERIC	Lower bound of the range	✓
High Value column	NUMERIC	Upper bound of the range	✓
Color By column	TEXT	Color category (optional)	—

-- Example: daily min/max temperature (optional: shift-based color)
SELECT
    day,
    MIN(temperature) AS temp_min,
    MAX(temperature) AS temp_max,
    shift AS shift_color
FROM sensor_log
WHERE day >= CURRENT_DATE - INTERVAL '7 days'
GROUP BY day, shift
ORDER BY day;

---

Next Step

→ 01 — Group Selection