Skip to content

4. Axis Config + Low/High — Range Column

In this step, the columns returned from the Compass record are bound to the widget's X axis, Low Value, and High Value fields. If Color By Column is optionally selected, a color is assigned to each category. In this flow the Y axis does not appear as a single column — it is split into the Low/High pair.

Wizard route: /cartography/add/axisconfig

Prerequisite

A Compass record must have been selected in Step 3 and the query result loaded.

03 — Compass Record Selection


1. Screen Layout

On the left are dropdowns (X axis, Low Value Column, High Value Column, optional Color By Column); on the right is the Data Preview table.

Range Column Axis Configuration screen


2. X Axis

Field Description Typical for Range Column
X Axis Type Data type of the X axis CategoryAxis (day, shift), DateTimeAxis (date series)
X Axis Column Query column to bind to X axis day, date, shift

3. Low Value Column (Key Field of This Flow)

Field Description
Low Value Column Numeric column to bind to the lower boundary of the bar

The Y axis starts with this field instead of a single column.

If Low Value Column is Empty

If this field is not filled, the Next button gives a warning: "Please select a Low Value column".


4. High Value Column

Field Description
High Value Column Numeric column to bind to the upper boundary of the bar

If High Value Column is Empty

If this field is not filled, the Next button gives a warning: "Please select a High Value column".

Low and High Same Column

If Low and High are bound to the same column, the bar height becomes 0 and it looks like a line. This is undesirable — make sure to select different columns.


5. Color By Column (Optional)

Field Description
Color By Column (Optional) Categorical column — a color for each unique value

When this field is filled, the Assign Colors panel opens below it:

Category Color
S1 🟦 blue
S2 🟧 orange
S3 🟩 green

Color By Scenarios

  • Shift-based coloring (S1/S2/S3)
  • Product code-based coloring (products A/B/C)
  • Device status (OK / Warning / Critical)

Colors Not Being Saved

First select the Color By Column, then assign colors. If the order is reversed, the colors will not be saved.


6. Data Preview Validation

The Data Preview on the right shows that the X / Low / High / Color By columns are correctly bound. Check:

  • Is Low ≤ High? (for each row)
  • Does the Color By column have 3-8 unique values?
  • Is the X column sorted?

7. Confirmation

When you click the Next button at the top right, the axis assignment is validated.


8. Next Step

07 — General Design

Steps 5 and 6 Are Skipped

For Range Column, Step 5 (Series Design) and Step 6 (Add Series) are skipped. You go directly to 7. General Design. Color assignment has been done in the Assign Colors panel in Step 4.