All Products
Search
Document Center

Quick BI:Histogram

Last Updated:Jan 20, 2025

A histogram is a graphical representation that organizes a group of data points into user-specified ranges, effectively illustrating the distribution's central tendency, dispersion, skewness, and kurtosis. This topic guides you through adding data to a histogram and customizing its appearance.

Prerequisites

You have created a dashboard. For more information, see Create a Dashboard.

Chart Overview

A histogram segments the timestamp range into continuous intervals, displaying the count of data points per interval with rectangular bars. This visual representation helps to convey the data distribution and the variances among data groups. image

  • Interval (also known as data bucket): The timestamp range is divided into several continuous, non-overlapping intervals.

  • Frequency: The count of data points within each interval.

  • Rectangular Bar: Each bar represents the quantity of data within an interval. The bar's width indicates the interval size, and its height reflects the frequency of values within that interval.

Scenarios

Histograms are commonly used in scenarios such as:

  • Analyzing trends in data centers, like customer satisfaction levels with products or services.

  • Examining data distributions, such as student grade distributions to assess teaching effectiveness.

  • Studying data dispersion, for instance, analyzing geographic temperature variances to gauge environmental stability.

  • Investigating data skewness, like understanding product preferences across different income levels.

  • Identifying data outliers to monitor product quality consistency and detect anomalies.

Advantages

  • Visualization: Enhance the intuitive display of data by customizing chart styles, including legends and tooltips.

  • Annotation: Add customizable annotations and endnotes with links to external paths for interactive data analysis.

  • Interactivity: Engage with data through drilling, filter interactions, and other dynamic operations.

Example of Effect

image

From a histogram analysis, you can discern:

  • Skewness: The asymmetry of the histogram's distribution shape indicates the skewness of the data.

    • A histogram with its long tail extending to the right is known as right skew (positive skew), indicating that the bulk of the data is clustered to the left.

    • A histogram with its long tail extending to the left is known as left skew (negative skew), indicating that most the data is clustered on the right.

  • Central Tendency: The histogram's shape helps estimate the mean, median, and mode positions, revealing the data's central tendency.

    • A symmetric distribution suggests the mean, median, and mode are near the histogram's center.

    • In a right-skewed histogram, the mean is greater than the median, with the mode on the left.

    • In a left-skewed histogram, the mean is less than the median, with the mode on the right.

  • Dispersion: Assess data spread by examining the histogram's width and the height variation of the bars.

  • Outliers: Isolated bars suggest potential outliers in the data set.

  • Kurtosis: The histogram's peak sharpness or flatness indicates the data distribution's concentration.

Chart Field Configuration

This section explains how to configure fields using an example of order quantity analysis across different product types.

  1. In the Data panel, assign fields to the appropriate areas under the Field tab by double-clicking or dragging. image

    • In the Value axis/Measure area, set the chart's primary metric for analysis.

      For instance, drag the Order Quantity field as the main metric for analysis.

  2. Click Update to refresh the chart automatically. image

  3. (Optional) To analyze by dimension, add dimension fields to the Color legend/Dimension area as needed. This will segment the bars according to the dimension field's values. For example, categorize order quantities by product type.

    In this case, drag the Product Type field to differentiate order amounts by product type. image

  4. (Optional) For multi-dimensional analysis, add necessary dimension fields to the Split/Dimension area to view data under different dimensions in facet mode.

    Here, drag the report_date(year) field to analyze order quantities by year. image

    Note

    Facet mode is limited to one dimension field and does not support thumbnail axis settings or advanced analysis features.

    • Style: The auxiliary display does not support the configuration of thumbnail axes.

    • Analysis: Supports data interaction settings only. Features such as advanced settings, analysis alerts, annotations, and intelligent insights are not available.

  5. (Optional) To display measure data in tooltips, add the measure to the Tooltip/Measure area. image

  6. (Optional) If you need to filter the displayed data, simply drag the desired field into the Filter area. For instance, to exclude data from specific regions, drag the Area field to the Filter area and click the image icon in the Set Filter window to apply the necessary filter. image

  7. (Optional) Auto-refresh

    Enable this option to refresh chart data automatically at set intervals. For example, setting it to refresh every 5 Minutes will update the chart accordingly. image

Chart Style Configuration

This section covers the chart's style settings. For general Title and Card configurations, refer to Configure the Chart Title.

image

Plot Area

Customize the histogram bars' style in the Plot area under the Style tab.

image

Chart configuration item

Configuration item description

Bar color scheme

Set the color scheme of the rectangular bars. Supports enabling gradient effects. 111

Data bucket calculation method

A data bucket is a rectangular bar obtained after grouping the data. The number of rectangular bars is the number of groups, and the width of each rectangle is the group interval. The calculation method of the data bucket supports setting to Default, Custom interval, or Custom number of groups.

  • Default: The system automatically groups according to the grouping function.

  • Custom interval: Automatically calculates and generates the corresponding bars based on the custom input interval and starting value. The upper limit of the number of groups is 50. image

  • Custom number of groups: Automatically generates the corresponding group interval based on the custom input number of groups. The upper limit of the number of groups is 50. image

Show interval value

Set whether to show the interval value and display position, which refers to setting it to display next to the x-axis title or above the chart. 111

Facet

Set the layout and style for charts arranged in facet mode in Facet.

Note

Facet mode applies only when fields are configured in Split/Dimension.

image

Chart configuration item

Description

Layout style

Set the chart arrangement layout. Supports Single column comparison and Network distribution modes.

Shared coordinate axis

Set whether the chart needs to share the same coordinate axis.

111

Show line separator

Set whether to show the line separator between charts.

When set to display, you can further configure the color and style of the line separator. 111

Number of columns

When the layout style is set to Network distribution, you can set the number of columns for chart arrangement.

The default is automatic. You can also customize the number of columns according to actual needs. 111

Note
  • The number of columns for PC and mobile terminals needs to be configured separately. You can switch the terminal configuration through the current page's top image.

  • The configurable range for the number of columns on the PC is 1-6; for mobile, it is 1-3.

Minimum width and height of facet block

Set the minimum width and height of each chart. Different layout styles support different configuration information.

  • Single row comparison, grid distribution with automatic number of columns: Only supports configuring the minimum width of the facet block.

  • Grid distribution with custom number of columns: Supports configuring the minimum width and height of the facet block.

Row and column pitch

Set the row and column pitch between charts. Different layout styles support different configuration information.

  • Single row comparison: Only supports configuring the column pitch between charts.

  • Network distribution: Supports configuring the row pitch and column pitch between charts.

Split label

Position

Set the display position of the dimension value label. Supports setting it Above the chart or Below the chart. 111

Text

Set the font color and style of the dimension value label. 111

Snap

Set the alignment of the dimension value label.

Coordinate Axis

Adjust the coordinate axis style in the Coordinate axis section under the Style tab. The default setting displays the axis.

image

Chart configuration item

Configuration content

Configuration item description

X-axis

Show X-axis

Set whether to show the X-axis. image

Show title and unit

Set whether to show the Title and Unit on the X-axis. Supports customizing the title name and the measurement unit to be used, and configuring the text style.

Show axis title

Set whether to show the axis title on the X-axis. If shown, set the Display format and Text style of the X-axis title.

Show scales

Set whether to show scales on the X-axis.

Show coordinate axis

Set whether to show the coordinate axis line of the X-axis. Supports customizing the coordinate axis style, including line type, line width, and color, when shown.

Show gridline

Set whether to show gridlines on the X-axis. Supports customizing the gridline style, including line type, line width, and color, when shown.

Left Y-axis

Show left Y-axis

Set whether to show the left Y-axis. image

Flip Y-axis

Set whether to flip the Y-axis. 111

Show title and unit

Set whether to show the Title and Unit of the left Y-axis. Supports customizing the title name and configuring the text style.

Show axis title

Set whether to show the title on the left Y-axis. If shown, set the Display format and Text style of the title.

Show scales

Set whether to show scales on the left Y-axis.

Show coordinate axis

Set whether to show the coordinate axis line of the left Y-axis. Supports customizing the coordinate axis style, including line type, line width, and color, when shown.

Show gridline

Set whether to show gridlines on the left Y-axis. Supports customizing the gridline style, including line type, line width, and color, when shown.

Legend

In the Legend section under the Style tab, set the chart's legend style. image

Chart configuration item

Configuration item description

Content

Choose whether to display the indicators of the background area in the legend. 111

Position

Set the display position of the legend. Supports the following four legend rendering methods.

image

Text

Set the text style of the legend. The font size supports separate settings for PC and mobile terminals, while the rest of the text style is configured uniformly.

Data Label

Configure the display and style of data labels in Data label.

Note

The Position and Text settings here are comprehensive. Customize data labels and formats for each measure or dimension value in Series settings.

image

Chart configuration item

Configuration item description

Content

Set the data content to be displayed in the chart, such as percentage or total.

Full display

Set whether to display all labels simultaneously, provided that the relevant data label status is displayed.

When the positions of the labels are close and the space is small, the labels will overlap. You can turn off full display to achieve visual clarity.

Position

Set the display position of the data label. Supports selecting Auto, Outside top of bar, Inside top, Inside bottom, Inside center, and Inside left.

Text

Set the format of the text in the data label.

Tooltip

Set tooltip preferences in the Tooltip section under the Style tab.

Note

Tooltip settings are available only on PC.

image

Chart configuration item

Configuration item description

Display method

Set the display method of the tooltip content. Supports selecting By single data point or By dimension value.

  • By single data point: Displays the data associated with the data point where the mouse hovers.

  • By dimension value: Displays all data under the same dimension value.

Content

Choose whether to display proportion information in the tooltip.

Background color

Set the background color of the tooltip box.

Text

Set the style of the tooltip text.

Series Settings

In Series settings, customize the series style.

image

Note

Set aliases and value display formats in Series Settings when Color Legend/dimension is enabled in the Fieldconfiguration panel.

Chart configuration item

Configuration item description

Select Field

Configure the label format for the required measure or dimension value.

Alias

Set the field name that fits the actual business scenario.

This item only supports configuration when Color legend/Dimension is configured.

Show Data Label

Choose whether to show data labels and set the color and position of the labels.

Value display format settings

Supports configuring the display format of values in data labels, provided that data labels are displayed. You can choose Auto fit, Custom fit, or manually input three formats.

This item only supports configuration when Color legend/Dimension is configured.

Show extreme values

Set whether to display labels for the maximum and minimum values in the measure.

This item only supports configuration when Color legend/Dimension is not configured.

Auxiliary Display

Configure indicator filters in the Auxiliary display section under the Style tab. image

Chart configuration item

Configuration item description

Enable indicator filter display

Set whether to enable indicator filter display. After enabling, you can configure the fields selected by default in the filter.

Show thumbnail axis

Set the display method of the thumbnail axis.

Chart Analysis Configuration

Chart configuration item

Configuration content

Configuration item description

Data interaction

Drilling

When you have set the drilling field in the field panel, you can set the drilling level row display style here. For more information, see Drilling.

Filter Interaction

When the data that you want to analyze belongs to different charts, you can configure this feature to associate the charts, and then analyze the data. For more information, see Filter interaction.

Jump

When the data that you want to analyze belongs to different dashboards, you can configure this feature to associate the dashboards, and then analyze the data. Jump includes Internal product jump, Component within page, and External link methods. For more information, see Jump.

Analysis Alert

Auxiliary Line

An auxiliary line can be used to show the difference between the value of a measure and the reference value indicated by the auxiliary line. The reference value can be a fixed value or a calculated value. You can use the following calculated values: average, maximum, minimum, and median. For more information, see Analysis alert.

Annotation

-

When there are anomalies or key points in the chart data, you can use color highlights, icons, comments, or data points for annotation to help identify anomalies and take appropriate actions. For more information, see Annotation.

What to Do next

  • To share the dashboard with others, see Share a Dashboard for detailed instructions.

  • For creating a complex navigation menu for thematic analysis, integrate the dashboard into the BI portal. For guidance, see BI portal.