Histogram

  • Axis parameter - Age

  • Values parameter - Bill Amount

  • Chart type - Histogram

  • Description - 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. Canvas settings for histogram charts

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

Last updated