Stacked Cartesian Flow

This flow covers Cartesian charts that automatically group components with the Stack By column. A single series design is performed; additional series are automatically generated from the unique categories in the Stack By column. Step 6 Add Series is skipped.

Chart Types Using This Flow

Chart Type	Primary Use	Page
Stacked Area Series	Stacked area — component + total trend	Stacked Area
Stacked Line Series	Stacked line — component trend	Stacked Line
Stacked Column Series	Stacked vertical bar — shift/category breakdown	Stacked Column
Stacked Bar Series	Stacked horizontal bar — long category names	Stacked Bar
Stacked Column 100 Series	100% normalized vertical bar — share analysis	Stacked Column 100
Stacked Bar 100 Series	100% normalized horizontal bar	Stacked Bar 100
Stacked Line 100 Series	100% normalized line — trend share	Stacked Line 100

Multi-Series Management Differs in the Stacked Flow

For Stacked types, Step 6 Add Series is skipped — each unique value categorized in the Stack By Column automatically becomes a stack layer. You do not need to add additional series manually.

---

Flow Diagram

flowchart LR
    A[1. Group<br/>Cartesian] --> B[2. Chart Type<br/>Stacked*]
    B --> C[3. Compass Entry]
    C --> D[4. Axis Config<br/>+ Stack By Column]
    D --> E[5. Series Design<br/>Color palette · Label]
    E --> G[7. General Design<br/>Title · Legend · Axis]
    G --> H[8. Card Design]
    H --> I[9. Display]

---

Step Pages

This flow runs 8 of the wizard steps (6 is not present):

#	Step	Page	Key Content
1	Group Selection	01 — Group Selection	Select the Cartesian card
2	Chart Type Selection	02 — Chart Type	7 Stacked sub-types
3	Compass Entry Selection	03 — Compass Entry	Query must include the Stack By column
4	Axis Config + Stack By	04 — Axis Config + Stack By	X/Y mapping + Stack By Column
5	Series Design	05 — Series Design	Color palette, data label
7	General Design	07 — General Design	Title, Legend (with category names), Axis
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
6 — Add Series	Add a second/third series to the chart	Each unique value in the Stack By column automatically becomes a separate stack layer; no manual series addition is required

---

Data Requirements

The Stacked flow expects the Compass entry to return at least three columns:

Column	Type	Role	Example
X column	TIMESTAMP / TEXT	Axis labels	shift_start, day
Y column	NUMERIC	Component value	production_count, energy_kwh
Stack By column	TEXT	Stack layer category	product_code, shift, line

-- Example: stacked column by shift, in product category
SELECT
    shift,
    product_code,
    SUM(count) AS production_count
FROM production_log
WHERE DATE(ts) = CURRENT_DATE
GROUP BY shift, product_code
ORDER BY shift, product_code;

In this query, shift is used as X axis, production_count as Y axis, and product_code as Stack By.

---

100% Normalized Variants

The Stacked Column 100, Stacked Bar 100, and Stacked Line 100 types share the flow; the only difference is that values on the Y axis are normalized to total 100 percent. The query structure is the same; the backend calculation is automatic.

Type	Y Axis Display
Stacked Column	Absolute count (e.g., 0-1500)
Stacked Column 100	Percentage share (0-100, auto-normalized)

---

Next Step

→ 01 — Group Selection