7.00.02 - Histogram (Hist) - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

Histograms are useful for assessing the shape of a data distribution. The Histogram function calculates the frequency distribution of a data set using sophisticated binning techniques that can automatically calculate the bin width and number of bins. The function maps each input row to one bin and returns the frequency (row count) and proportion (percentage of rows) of each bin.

The Aster Analytics histogram implementation, redesigned for release 6.21, includes the following capabilities:

  • User-selected or automatic bin determination
  • User-selected left-inclusive or right-inclusive binning
  • Multiple histograms for distinct groups