Histogram Results - Teradata Warehouse Miner

Teradata Profiler Plug-in User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
tjx1484331808948.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2304
lifecycle
previous
Product Category
Software

Histogram analysis results can be viewed in a grid, as thumbnails, and in graphs.

Grid View

Name Type Definition
xdb VARCHAR (128) Database that the variable for the values operation resides in, as specified by the database parameter.
xtbl VARCHAR (128) Table that the variable for the statistics operation resides in, as specified by the table parameter.
xcol VARCHAR (128) Variable that the statistics operation will be run against, as specified by the "column" parameter.
xbin INTEGER An integer representing the bin number.
xbeg FLOAT Value that represents the beginning boundary for the bin of the column specified.
xend FLOAT Value that represents the ending boundary for the bin of the column specified.
xcnt FLOAT Number of records in the bin.
xpct FLOAT Percentage of total records that this bin represents.
ovly_COL Overlay Column Type Value of the column to overlay within the bin. This only exists if Overlay Columns is specified. COL indicates the name or alias of the requested overlay column. This column consist of unique categorical values that subdivide the bin.
xocnt FLOAT Number of records within the bin in which this overlay column is present. This only exists if Overlay Columns is specified.
xobcpt FLOAT Percentage of total records within the bin in which this overlay column value is present. This only exists if Overlay Columns is specified.
xopct FLOAT Percentage of total records in which this overlay column value is present.This only exists if Overlay Columns is specified.
xmin_COL FLOAT Minimum value of the Stats column within the bin. This only exists if Stats Column is specified. COL is the name or alias of the requested Stats column.

Multiple columns, if specified, are created or displayed as a repeating group consisting of xmin_COL, xmax_COL, xmean_COL, and xstd_COL for each COL name or alias.

xmax_COL FLOAT Maximum value of the Stats column within the bin. This only exists if Stats Column is specified. COL is the name or alias of the requested Stats column.
xmean_COL FLOAT Mean (average) value of the Stats column within the bin. This only exists if Stats Column is specified. COL is the name or alias of the requested Overlay column.
xstd_COL FLOAT Standard deviation of the Stats column within the bin. This only exists if Stats Column is specified. COL is the name or alias of the requested Overlay column.

Thumbnail View

The Histogram Thumbnail view displays results as thumbnails grouped by database and table of all the possible graph generations per column.

Graph View

The Histogram graph will display the Bin Range and Count for each selected Bin.

If Overlay columns were selected, you can add overlay information to the graph and choose the Overlay column. The Overlay option adds frequencies within each bin that are calculated for each value of that overlay column.

If Statistic columns were selected, you can add statistic information to the graph and choose the Statistic column. The Statistic option adds the box and whisker plot graph of the Statistics (Maximum, Mean + Standard Deviation, Mean, Mean – Standard Deviation and Minimum values) results for the selected column values.