3. Compass Record Selection — Dynamic Text
In this step you select the Compass record that the Dynamic Text widget will use. Your record must return a single row with a single value; this value is dynamically reflected on the card.
Wizard route: /cartography/add/selectcompass
1. Compass Record List
2. Suitable Record Structure for Dynamic Text
-- Instantaneous daily production
SELECT SUM(count) AS daily_production
FROM production_log
WHERE DATE(ts) = CURRENT_DATE;
-- Today's revenue
SELECT ROUND(SUM(amount), 2) AS todays_revenue
FROM orders
WHERE DATE(ts) = CURRENT_DATE;
| Column | Role in Step 4 | Type |
|---|---|---|
| Single value column | Y Axis Column | NUMERIC or TEXT |
Single Row Is Mandatory
If more than one row is returned, Dynamic Text uses only the first row. Guarantee this with aggregates (SUM, COUNT, MAX) or LIMIT 1.
Instant vs Aggregate
- Instantaneous value (temperature, OEE): MQTT or
LIMIT 1for the latest row - Aggregate KPI (daily total, average): aggregate with
GROUP BYor date filter
3. Compatible Data Sources for Dynamic Text
| Data Source | Dynamic Text Compatibility |
|---|---|
| MQTT (live) | ✅ Ideal (instantaneous value) |
| PostgreSQL / MSSQL / MySQL | ✅ Suitable |
| REST API | ✅ Suitable |
| Excel Offline | ⚠️ Limited (not live) |
4. Search and Tag Filter
| Action | Effect |
|---|---|
| Search box | Instant filter |
| Tag filter | Only tags in use |
| Clear | Reset filters |
Dynamic Text Tags
Use kpi, dynamic-text, live tags in Compass for Dynamic Text queries.
5. Confirm the Record
When you click a record the row is highlighted. Click the Next button at the top right to proceed.
Proceeding Without Selecting a Record
If no record is selected, Next gives a warning.
6. Excel Offline Sheet Selection
For Excel records, an additional Sheet dropdown appears.
7. Preview Execution
When you press Next, the record is executed and the result is held in memory.
8. Common Errors
| Symptom | Likely Cause | Resolution |
|---|---|---|
| Dynamic Text shows 0 / blank | Record returns an empty row | Test the query in Compass |
| Multiple rows returned | Aggregate missing | Add SUM, COUNT, or LIMIT 1 |
| Column dropdown empty in Step 4 | No numeric/text column | Make the query return a column |