Dynamic Text Flow

This flow covers the 7 steps for the Dynamic Text widget, which displays a single value from a Compass record as a KPI card. The single value column mapping is done in Step 4; Steps 5 and 6 are skipped. The format string ({value}%, {value} USD) is defined in Step 7.

Chart Types Using This Flow

Chart Type	Primary Use	Page
Dynamic Text	Single-value KPI card (Daily Production, Instantaneous Fill, etc.)	Dynamic Text

Static Text Is a Separate Flow

Static Text is not connected to a data source. → Static Text Flow

---

Flow Diagram

flowchart LR
    A[1. Group<br/>Text] --> B[2. Chart Type<br/>Dynamic Text]
    B --> C[3. Compass Record]
    C --> D[4. Axis Config<br/>Single Value Column]
    D --> G[7. General Design<br/>Format · Color · Icon]
    G --> H[8. Card Design]
    H --> I[9. Display Info]

---

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 Text card
2	Chart Type Selection	02 — Chart Type	Dynamic Text card
3	Compass Record Selection	03 — Compass Record	Single row, single value
4	Axis Config — Single Value Column	04 — Axis Config	Y Axis Column = value to display
7	General Design — Format String	07 — General Design	Text Format (Default/Percent/TL/USD/EUR), Icon, Wave
8	Card Design	08 — Card Design	Refresh, Border, Info Card
9	Display Information	09 — Display Info	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	Dynamic Text displays a single numeric/text value; there is no chart series concept
6 — Add Series	Add a second/third series to the chart	A single-value KPI card does not support multiple series

---

Data Requirements

The Dynamic Text query must return a single row with a single value.

-- Instantaneous daily production
SELECT SUM(count) AS daily_production
FROM production_log
WHERE DATE(ts) = CURRENT_DATE;

Column	Type	Role
Value column	NUMERIC or TEXT	Value displayed on the card

Numeric vs Text

For numeric values use NUMERIC (e.g., 1245); for KPI text use TEXT (e.g., "Above target") — both are supported.

---

Next Step

→ 01 — Group Selection