Skip to main content

Histogram options

This section covers the configuration options for histogram chart visualizations created in the SQL editor or a notebook. For an example, see histogram 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:

  • X Column: Select the results column from the dataset to display.
  • Number of Bins: Number of bins in which to display the data.

X axis​

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

  • Scale: Select Automatic, Datetime, Linear, Logarithmic, or Categorical.
  • Name: Specify a display name for the X axis column if different from the column name.
  • Show labels: Whether to show X axis labels.
  • Hide axis: Whether to hide the X axis labels and line.

Y axis​

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

  • 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: If enabled, hides the Y axis labels and scale markers.

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.