Heatmap options
This section covers the configuration options for heatmap chart visualizations in the SQL editor or a notebook. For an example, see heat map 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: The part of the query result to use to divide the data into rows, such as days of the week.
- Y Columns: The part of the query result to use to divide the data into rows, such as trip distance.
- Color Column: The part of the query result that determines the color for each grid area, such as trip fare.
X axis
To configure formatting options for the X axis, click X axis and configure the following optional settings:
- Scale: Automatic (Categorical) or 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: Categorical is the only option.
- Name: Override the column name with a different display 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.
- 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.
Colors
To configure colors, click Colors and optionally override automatic colors and configure custom colors:
- Name: Override the legend name with a different display name.
- Color scheme: Specify a custom color scheme.
Data labels
To configure labels for each data point in the visualization, click Data labels and configure the following optional settings:
- Show data labels: Whether to show data labels. Data labels can add visual clutter and are usually disabled for heatmaps.
- 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.