Optional Syntax Elements for TD_Histogram - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
ON clause for Dimension
Accept the MinMax table clause.
NBins
[Required with methods Equal-Width and Variable-Width] Specify the integer value which will specify the number of ranges or bins.
If only one value is specified, it is applied to all the target columns. Otherwise, the number of NBins values must be equal to the number of target columns.
The maximum NBins value is 10000.
Inclusion
Specify whether to include points on bin boundaries, in the bin to the left of the boundary or the bin to the right of the boundary.
If only one value is specified, it is applied to all the target columns. Otherwise, the number of Inclusion values must be equal to the number of target columns.
Default: left
GroupByColumns
Specify the names of the InputTable columns that contain the group values for binning.
This argument must not have columns that are already specified in TargetColumn.
This argument does not support range.
The maximum number of unique columns in the GroupByColumns argument is 2042.