5.4.4 - Frequency 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

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

Grid View

The grid view of a Frequency analysis contains the following data, depending on the options you selected.

Name Type Definition
xtbl VARCHAR (128) Tables that the variable for the statistics operation resides in, as specified by the table parameter.
xcol VARCHAR (128) Variable that the statistics operation runs against, as specified by the column parameter.
xval VARCHAR (256) Distinct values of the frequency variable.
xcnt FLOAT Count of the number of rows that the frequency variable is equal to the distinct value specified in xval.
xpct FLOAT Percentage of the total records where the frequency variable is equal to the distinct value specified in xval.
xmin_COL FLOAT If Statistics Column is selected, this column is created to represent the minimum value of the column specified for the given frequency value (xval).
xmax_COL FLOAT If Statistics Column is selected, this column is created to represent the maximum value (xval).
xmean_COL FLOAT If Statistics Column is selected, this column is created to represent the mean value of the column specified for the given frequency value (xval).
xstd_COL FLOAT If Statistics Column is selected, this column is created to represent the mean value of the column specified for the given frequency value (xval).

Thumbnail View

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

Graph View

The Frequency Analysis graph displays 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.