TD_UnivariateStatistics Syntax Elements - 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ā„¢
TargetColumns
Specify the names of the numeric InputTable columns for which to compute statistics.
PartitionColumns
[Optional] Specify the names of the InputTable columns on which to partition the input. The function copies these columns to the output table.
Default behavior: The function treats all rows as a single partition.
Stats
[Optional] Specify the statistics to calculate. statistic is one of these:
  • SUM
  • COUNT or CNT
  • MAXIMUM or MAX
  • MINIMUM or MIN
  • MEAN
  • UNCORRECTED SUM OF SQUARES or USS
  • NULL COUNT or NLC
  • POSITIVE VALUES COUNT or PVC
  • NEGATIVE VALUES COUNT or NVC
  • ZERO VALUES COUNT or ZVC
  • TOP5 or TOP
  • BOTTOM5 or BTM
  • RANGE or RNG
  • GEOMETRIC MEAN or GM
  • HARMONIC MEAN or HM
  • VARIANCE or VAR
  • STANDARD DEVIATION or STD
  • STANDARD ERROR or SE
  • SKEWNESS or SKW
  • KURTOSIS or KUR
  • COEFFICIENT OF VARIATION or CV
  • CORRECTED SUM OF SQUARES or CSS
  • MODE
  • MEDIAN or MED
  • UNIQUE ENTITY COUNT or UEC
  • INTERQUARTILE RANGE or IQR
  • TRIMMED MEAN or TM
  • PERCENTILES or PRC
  • ALL
Default: ALL
Centiles
[Optional] Specify the centile to calculate. percentile is an INTEGER in the range [1, 100].
The function ignores Centiles unless Stats specifies PERCENTILES, PRC, or ALL.
Default: 1, 5, 10, 25, 50, 75, 90, 95, 99
TrimPercentile
[Optional] Specify the trimmed lower percentile, an integer value in the range [1, 50]. The function calculates the mean of the values between the trimmed lower percentile (trimmed_percentile) and trimmed upper percentile (1-trimmed_percentile).
The function ignores TrimPercentile unless Stats specifies TRIMMED MEAN, TM, or ALL.
Default: 20