4. Axis Configuration — Circular
In this step, the columns returned from the Compass record are assigned to the widget's X (label) and Y (value) fields. Stack By, Low/High fields are not visible in the Circular flow.
Wizard route: /cartography/add/axisconfig
Prerequisite
A Compass record must have been selected in Step 3 and the query result loaded.
1. Screen Layout
On the left are dropdowns (X axis, Y axis); on the right is the Data Preview table showing the first rows of the query result.
2. X Axis (Slice Label)
| Field | Description | Typical for Circular |
|---|---|---|
| X Axis Type | Data type of the X axis | CategoryAxis (recommended) |
| X Axis Column | Slice name column | product_code, shift, category |
X Axis Type for Circular
Circular charts generally use CategoryAxis — slices are categorical labels. DateTimeAxis or NumericAxis is not meaningful for Circular.
3. Y Axis (Slice Value)
| Field | Description |
|---|---|
| Y Axis Type | NumericAxis (numeric) |
| Y Axis Column | Numeric column holding the slice size |
Y Column Must Be Numeric
The Y dropdown shows only numeric columns. Use aggregates like SUM(...), COUNT(...) in SQL.
4. Type-Specific Notes
4.1 Pie / Doughnut
The slice name and value are sufficient; no additional mapping needed.
4.2 Radial Bar
In Radial Bar, each row becomes a separate radial ring. The query must return multiple rows; each row contains a category name + progress percentage/value.
-- For Radial Bar: multiple targets
SELECT
machine_name AS ring_label,
oee_percent AS ring_value -- 0-100 range
FROM oee_machine
WHERE DATE(ts) = CURRENT_DATE
ORDER BY oee_percent DESC;
5. Data Preview Validation
The Data Preview on the right shows that the X and Y columns are correctly bound. Check:
- Does the X column have 3-6 unique values?
- Is the Y column numeric and positive? (negative values are meaningless in Circular)
Negative Values
Circular charts cannot render negative values — the value is taken as absolute and converted to slice share. Protect with ABS(...) in SQL or filter for positive values.
6. Confirmation
When you click the Next button at the top right, the axis assignment is validated.