Results Data | Histogram Analysis | Vantage Analytics Library - Results Data - Vantage Analytics Library

Vantage Analytics Library User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Vantage Analytics Library
Release Number
2.2.0
Published
March 2023
Language
English (United States)
Last Update
2024-01-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage

The following table describes the function results data. If the function creates an output table, the bold columns comprise its Unique Primary Index (UPI).

For important information about bin boundaries, see binstyle in Syntax.

With style (basic) (Default)
Column Data Type Description
xtbl VARCHAR (128) Table against which bin values are computed, specified by tablename.
xcol VARCHAR (128) [Column appears once for each column specified by columns.] Name or alias of column against which bin values are computed.
xbin INTEGER Bin number of column.
xbeg FLOAT Beginning boundary for bin of column.
xend FLOAT Ending boundary for bin of column.
xcnt FLOAT Count of rows in bin.
xpct FLOAT Percentage of rows in bin.
ovly_column_name Overlay Column Type [Column appears once for each column specified by overlaycolumnsValue of column to overlay within bin (unique categorical values into which bin is divided).
xocnt FLOAT [Column appears once for each column specified by overlaycolumns.] Number of rows within bin in which overlay column value appears.
xobpct FLOAT [Column appears once for each column specified by overlaycolumns.] Percentage of rows within bin in which overlay column value appears.
xopct FLOAT [Column appears once for each column specified by overlaycolumns.] Percentage of all rows in which overlay column value appears.
xmin_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Minimum value of statistics column within bin.
xmax_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Maximum value of statistics column within bin.
xmean_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Mean (average) of statistics column within bin.
xstd_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Standard deviation of statistics column within bin.

For date column, standard deviation is in days.

With style (crosstab) (Multidimensional)
Column Data Type Description
xbin_column_name INTEGER [Column appears once for each column specified by columns.] Bin number of column.
xbeg_column_name FLOAT [Column appears once for each column specified by columns.] Beginning boundary for bin of column.
xend_column_name FLOAT [Column appears once for each column specified by columns.] Ending boundary for bin of column.
xcnt FLOAT Count of rows in bin.
xpct FLOAT Percentage of rows in bin.
ovly_column_name Overlay Column Type [Column appears once for each column specified by overlaycolumns.] Value of column to overlay within bin (unique categorical values into which bin is divided).
xocnt FLOAT [Column appears once for each column specified by overlaycolumns.] Number of rows within bin in which overlay column value appears.
xobpct FLOAT [Column appears once for each column specified by overlaycolumns.] Percentage of rows within bin in which overlay column value appears.
xopct FLOAT [Column appears once for each column specified by overlaycolumns.] Percentage of all rows in which overlay column value appears.
xmin_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Minimum value of statistics column within bin.
xmax_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Maximum value of statistics column within bin.
xmean_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Mean (average) of statistics column within bin.
xstd_column_name FLOAT [Column appears once for each column specified by statisticscolumns.] Standard deviation of statistics column within bin.

For date column, standard deviation is in days.