|
## Specifications
### Aggregation
In XY charts, the [X-axis is a dimension and the Y-axis is a metric](https://docs.codatum.com/data-exploration/chart-common#dimension-metric), and Y-axis values are aggregated for each X-axis value. (In [XYZ charts](https://docs.codatum.com/data-exploration/chart/xyz-chart), the X-axis and Y-axis are dimensions and the Z-axis is a metric, so Z-axis values are aggregated for each combination of X and Y.)
| Item | Role | Notes |
| ----------- | --------- | ----------------------------------- |
| X-axis | Dimension | Aggregation unit (aggregated per X) |
| Y-axis | Metric | Adds a series per metric |
| Grouping | Dimension | Splits series by value |
| Bubble size | Metric | Only for bubble rendering |
#### Example Configurations
* Show "Monthly total sales" as a line chart
* X-axis (Dimension): Month
* Y-axis (Metric): Total sales
* Show "Total sales by product category" as a bar chart
* X-axis (Dimension): Product category
* Y-axis (Metric): Total sales
### X-Axis Specifications
In XY charts, the X-axis type is determined by the **X-axis data type** and the **render type composition**.
| X-axis data type | Render type composition | X-axis classification |
| ---------------- | ------------------------- | --------------------- |
| Date/Datetime | All | Time axis |
| Numeric | Scatter/Bubble/Line only | Numeric axis |
| Numeric | Includes Bar/Area/Stacked | Categorical axis |
| Other | All | Categorical axis |
#### Categorical Axis
In a categorical axis, even if the specified values are numeric or date/datetime types, they are rendered as discrete values at equal intervals.
**Specifying Axis Upper and Lower Limits**
When specifying upper or lower limits for a categorical axis, the specified values are treated as indices of the data order (0th, 1st, 2nd...).
| Index | X-axis value |
| ----- | ------------ |
| 0th | `1` |
| 1st | `10` |
| 2nd | `20` |
| 3rd | `30` |
| ... | ... |
| 10th | `100` |
In this case, if you set the axis upper limit to `10`, data up to the 10th index will be displayed, which means X-axis values up to `100` will be shown.
#### Time Axis
In a time axis, the specified date/datetime type data is rendered as a continuous time series.
* Axis labels are dynamically determined based on the specified date/datetime data
* When datetime data with a timezone is specified, it is converted to the timezone specified in the browser for rendering
* Axis labels are displayed based on the browser time zone. Therefore, if the browser time zone does not match the data time zone, axis labels and data labels may be misaligned
* Converting to a datetime format without a time zone can also prevent the browser time zone from affecting the dates and times
#### Numeric Axis
In a numeric axis, the specified numeric type data is rendered as continuous numeric values.
## Tips
### Multiple Series
When you configure multiple series, a "Indepedent scale" option appears in the series settings. Turning it on gives that series its own Y-axis scale, drawn on the right.
Configure labels and other options for independent Y-axes under "Advanced" > "Independent axes".
| |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
When you configure multiple series, a "Split by series" option appears below the "Series" settings. Turning it on gives each series its own Y-axis scale and stacks the charts vertically, one per series.
Enabling "Split by series" disables the [frame feature](#frame-feature). The "Indepedent scale" option is also hidden, and every series is treated as having an independent axis. Configure per-series Y-axes under "Advanced" > "Independent axes".
| |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
### Frame Feature
XY charts support the frame feature. See [Frame Feature](https://docs.codatum.com/data-exploration/chart-common#frame-feature) for details.
### Reference Line
In XY Charts and XYZ Charts, you can add reference lines to the X-axis and Y-axis. By displaying reference lines or regions such as target values, acceptable ranges, or danger zones, you can visually support data evaluation. Y-axis reference lines are displayed horizontally, and X-axis reference lines are displayed vertically.
| |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
* Configuration Method
* In the chart edit screen "Advanced Settings", select the axis where you want to display the reference line, then click "Reference Line" > "Add". Enter the type and value of the reference line you want to display.
* What You Can Do
* Line: Display a dashed line at a specific value (e.g., sales target, threshold, specific date marker)
* Band (Range): Display a semi-transparent band for a specific range (e.g., acceptable range, danger zone, caution period)
* Color and Label Settings: Choose colors from success (green), warning (yellow), danger (red), and add labels as needed
### Trend
In XY Charts and XYZ Charts, you can display trend lines (such as regression lines or moving averages) for series. Trend lines are added as separate series from the original data, helping you visually understand data trends.
| |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
* Configuration Method
* In the chart edit screen "Advanced Settings", click "Series" > "Trend" > "Display" and select the type of trend you want to display.
* Trend lines are displayed as dashed lines, and for trend types other than moving average, the equation and R² (coefficient of determination) are displayed on the chart. (The coefficient of determination can be hidden.)
#### Trend Types
| Trend Type | Description | Additional Settings |
| -------------- | ------------------------------------------------- | -------------------------- |
| Linear | Displays linear regression (y = mx + c) | None |
| Polynomial | Displays polynomial regression | Specify degree from 2 to 5 |
| Moving Average | Displays moving average | Specify window size |
| Exponential | Displays exponential regression (y = ae^(bx)) | None |
| Logarithmic | Displays logarithmic regression (y = a + b ln(x)) | None |
| Power | Displays power regression (y = ax^b) | None |
Note: Trend lines will not be displayed if the data count is insufficient or if applying the specified trend type fails.
### Statistics
In XY Charts and XYZ Charts, you can display statistical values (mean, median, maximum, minimum) of series as dashed lines.
| |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
* Configuration Method
* In the chart edit screen "Advanced Settings", click "Series" > "Statistics" > "Display" and select the statistical values you want to display.
* The dashed lines will display the statistics type and its value as labels.
#### Difference from Trends
| Feature | Statistics | Trend |
| ------------------ | ------------------------------------------------ | ------------------------------------------- |
| Display Format | Displayed as the same series | Added as a separate series (trend line) |
| When Zooming Chart | Recalculated only with data in the visible range | Not recalculated (always based on all data) |
| In Stacked Charts | Appears as a stacked differential | Not stacked |
