Histogram

A histogram shows how often values fall within specific ranges, helping you quickly identify the distribution, such as whether values are concentrated, spread out, or skewed.

Chart setup

  1. Axis

- Drag the dimension to plot on the axis (e.g.,Age).

  1. Values parameter

- Drag the measure you’d like to analyze to view its distribution in the histogram (e.g., Bill Amount).

  1. Chart type

- Select Histogram Chart from the Chart Type dropdown menu.

Histograms provide a graphical representation of data distribution, making it easier to identify patterns. In this example, the histogram shows the bill amount for specific age groups.

Pivot data for Histogram

1. Customization & formatting under Canvas settings

1.1. Show cumulative bar

In a traditional histogram, bin values are totaled separately. In a cumulative histogram, each bin is the sum of the values in a bin and all previous bins.

Cumulative histogram
Traditional histogram

1.2. Bin

  • Options: You can plot the histogram by specifying the interval or defining the total number of bins. You need to specify the number of bins or the size of each bin accordingly.

Histogram based on number of bins
Histogram based on size of bins
  • Type: Histograms plotted based on the number of bins can have closed intervals or semi-closed intervals.

Semi closed interval
Fully closed interval

1.3. Underflow bin

An underflow bin is used to group all data points that fall below the minimum value of the range of the defined bins. This is particularly useful when dealing with datasets where some values lie outside the specified range and need to be accounted for separately.

Underflow bin

1.4. Overflow bin

Similar to underflow bins, you can define an upper limit with overflow bins.

Overflow bin

1.5. Gap width

Define the space between consecutive bins.

Gap width for histograms

Additional formatting options

Here are the other settings that help you refine your Histogram.

Feature
Description
Link

Number

Configure number formatting (decimals, units)

Legend

Show/hide and customize the legends

Data Label

Show exact values for each data point

Trellis

Create small multiples using category split

Conditional Formatting

Apply color rules to highlight values

Sorting

Sort axis order

Ranking

Limit to top/bottom N categories

Last updated

Was this helpful?