Skip to main content
Last updated on

Box options

This section covers the configuration options for box chart visualizations created in the SQL editor or a notebook. For an example, see bar chart example.

To learn how to work with visualizations in AI/BI dashboards, see Dashboard visualizations.

General​

To configure general options, click General and configure each of the following required settings:

  • Horizontal Chart: If selected, the box, which shows number distribution, is plotted along the X axis.
  • X column: X axis values. For a vertical chart, choose a categorical column. For a horizontal chart, choose a number column.
  • Y columns: Y axis values. For a vertical chart, choose a number column. For a horizontal chart, choose a categorical column.
  • Group by: Additional columns to group by, after the default grouping is applied. By default, results are grouped by the X axis unless Horizontal Chart is also selected, in which case results are grouped by the Y axis.
  • Legend placement: Automatic (Flexible), Flexible, Right, Bottom, or Hidden.
  • Legend items order: Normal or Reversed.
  • Show all points: Whether to show each X axis value separately or to show the range of values using a box.
  • Missing and NULL values: Whether to hide missing or NULL values or to convert them to 0 and show them in the visualization.

X axis​

To configure formatting options for the X axis, click X axis and configure the following optional settings:

  • Scale: Categorical.
  • Name: Override the column name with a different display name.
  • Sort values: Whether to sort the X axis values, even if they are not sorted in the query.
  • Reverse Order: Whether to reverse the sorting order.
  • Show labels Whether to show the X axis values as labels.
  • Hide axis: If enabled, hides the X axis labels and scale markers.

Y axis​

To configure formatting options for the Y axis, click Y axis and configure the following optional settings:

  • Scale: Automatic (Linear), Datetime, Linear, Logarithmic, or Categorical.
  • Name: Specify a display name for the Y axis column if different from the column name.
  • Start Value: Show only values higher than a given value, regardless of the query result.
  • End Value: Show only values lower than a given value, regardless of the query result.
  • Hide axis: Whether to hide the Y axis labels and line.

Series​

To configure series, click Series and configure the following optional settings:

  • Order: The order the values appear in the box chart.
  • Label: The label for the values in the legend.

Colors​

To configure colors, click Colors and optionally override automatic colors and configure custom colors.

Data labels​

To configure labels for each data point in the visualization, click Data labels and configure the following optional settings:

  • Number values format: The format to use for labels for numeric values.
  • Percent values format: The format to use for labels for percentages.
  • Date/time values format: The format to use for labels for date/time values.
  • Data labels: The format to use for labels for other types of values.
On this page