Quick BI:Heat Map

Prerequisites

A dashboard is created. For more information, see Create a Dashboard.

Overview

Scenarios

It is commonly used in models such as shopping cart analysis.

Advantages

Visualization effects: You can configure two styles: Standard Heat Map and Polar Heat Map.

Examples

Field Configuration

1. On the Fields tab on the right side of the chart, select the required dimension fields and measure fields.

   • In the Dimensions list, find the Province field, and double-click or drag it to the X-axis/Dimension section to use it as the x-axis of the chart.

   • In the Dimensions list, find the Product Type field, and double-click or drag it to the Y-axis/Dimension section to use it as the y-axis of the chart.

   • In the Measures list, find the Order amount field, and double-click or drag it to the Heat Depth section to use it as the basis for the color depth of the chart.

   • (Optional) When you need to reflect data through the size of heat blocks, you can drag relevant measure fields to the Shape Size/Measure section.

2. Click Update. The system automatically updates the chart. The updated chart is displayed as follows.

3. (Optional) When you only need to view data for specific provinces, you can set a filter to filter out the required data.

   For more information about field filtering, see Field filtering.

4. Auto Refresh

   After you select Auto Refresh, the system automatically refreshes the heat map at a specified time interval. For example, if you select Auto Refresh, enter 5, and then select min, the system refreshes the chart every 5 minutes.

Style Configuration

• For the style configuration of Title and Card, see Configure the Chart Title.

• In the Heat Area section, configure the visualization style, data mapping interval, heat color, and transparency.

  Configuration item	Description
  Visualization Style	You can configure two styles: Standard Heat Map and Polar Heat Map.
  Color Settings	When a dimension field is configured in the Heat Depth section of the Fields panel, you can configure a color for each dimension value here.
  Data Mapping Interval	You can configure Equal Interval, Continuous Interval, and Custom Interval. Equal Interval You can configure 2 to 10 intervals. Continuous Interval Continuous interval is selected by default. Custom Interval You can configure 2 to 10 intervals. For interval division basis, you can configure by absolute value or by percentage, and set the minimum and maximum values.
  Heat Color	You can configure Sequential Gradient and Diverging Gradient.
  Transparency	You can configure transparency in the range of 0% to 100%.
  Show Line Separator	Specifies whether to show line separators between heat blocks and their color.
  Heat Block Shape	When a field is dragged to the Shape Size/Measure section of the Fields panel, you can set the Shape Size of heat blocks here.
  Heat Area Pitch	You can configure the pitch between heat blocks in the range of 0 to 20px. Note Only Standard Heat Map supports configuring heat area pitch.
  Heat Area Border Radius	You can configure the border radius of heat blocks in the range of 0 to 20px. Note Only Standard Heat Map supports configuring heat area border radius.
  Abnormal Value Processing	You can configure not to display abnormal values or customize the display of abnormal values.

• In the Axes section, configure the axis style.

  Note

  The following are the configuration items and descriptions for the Standard Heat Map axes. For Polar Heat Map axes, you only need to configure Show External Axis Labels and Show Internal Axis Labels.

  Name	Configuration item	Description
  X-axis	Show X-axis	Specifies whether to show the x-axis and sets the position of the x-axis at the top or bottom of the chart.
  	X-axis Position	Sets the position of the x-axis at the top or bottom of the chart.
  	Show Title And Unit	Specifies whether to show the Axis Title and Unit on the x-axis.
  	Show Axis Labels	Specifies whether to show axis labels on the x-axis, along with the axis label display rules and text style. Axis label display rules support Smart Display, Force Sparse, and Maximum Display.
  	Show Scales	Specifies whether to show scales on the x-axis.
  	Show Axis	Specifies whether to show the x-axis and the axis style, including line type, line width, and color.
  Left Y-axis	Show Left Y-axis	Specifies whether to show the left y-axis.
  	Show Title and Unit	Specifies whether to show the axis title and unit on the y-axis.
  	Show Axis Labels	Specifies whether to show axis labels on the left y-axis, along with the axis label display rules and text style.
  	Show Scales	Specifies whether to show scales on the left y-axis.
  	Show Axis	Specifies whether to show the left y-axis and the axis style, including line type, line width, and color.

  Note

  The above are the configuration items and descriptions for the Standard Heat Map axes. For Polar Heat Map axes, you only need to configure Show External Axis Labels and Show Internal Axis Labels.

• In the Legend section, configure the position and format of the legend.

  Configuration item	Description
  Legend Type	When Data Mapping Interval in the heat area is set to Equal Interval or Custom Interval, you can select the legend type here. The options are Continuous, Classification, and Block.
  Content	When fields are dragged to both the Heat Depth and Shape Size sections of the Fields panel, you can select which field's legend to display here.
  Position	Sets the position of the legend in the chart.
  Text	Sets the text format of the legend.

• In the Data Labels section, specify whether to display data labels.

  

• In the Tooltip section, configure the tooltip style.

  

• In the Conditional Format section, configure the format to display when data meets certain conditions. Click the icon under Conditional Style , select the Icon option in the Conditional Format Configuration dialog box, and configure related settings.

  Note

  Only Standard Heat Map supports conditional formatting.

  

  Configuration item		Description
  Rule Definition	Based on Field	Select the field for which you want to configure conditional formatting.
  	Condition Selection	Select the comparison method for the data. The options are Compare with Fixed Value and Compare with Dynamic Field. Compare with Fixed Value: Compare with a fixed value. For example, the condition rule is that sales exceed 600,000. This method is suitable for scenarios where you need to monitor fixed thresholds. Compare with Dynamic Field: Compare with the value or calculation result of other fields. For example, the condition rule is exceeding 20% of last month's sales. This method is suitable for scenarios where you need to dynamically adjust evaluation standards based on changes in external factors such as time.
  	Condition Rule	Select the icon for the current condition rule and define the specific comparison rule. When the condition is set to Fixed Value: Enter the fixed standard value for the comparison rule here. When the condition is set to Dynamic Field: Select the specific field for comparison and its calculation method here.
  More Settings		Set the size of the icons displayed in the chart.

• In the Auxiliary Display section, configure thumbnails for the x-axis and y-axis.

  

  Note

  Only Standard Heat Map supports configuring thumbnails.

Chart Analysis Configuration