Skip to main content

A set of string constants for the parameter AggregateStatisticsRequest.stats. More…

​
Static Public Attributes

const string COUNT = “count”
 Number of objects (independent of the given column(s)).
 
const string MEAN = “mean”
 Arithmetic mean (average), equivalent to sum/count.
 
const string STDV = “stdv”
 Sample standard deviation (denominator is count-1).
 
const string VARIANCE = “variance”
 Unbiased sample variance (denominator is count-1).
 
const string SKEW = “skew”
 Skewness (third standardized moment).
 
const string KURTOSIS = “kurtosis”
 Kurtosis (fourth standardized moment).
 
const string SUM = “sum”
 Sum of all values in the column(s).
 
const string MIN = “min”
 Minimum value of the column(s).
 
const string MAX = “max”
 Maximum value of the column(s).
 
const string WEIGHTED_AVERAGE = “weighted_average”
 Weighted arithmetic mean (using the option WEIGHT_COLUMN_NAME as the weighting column).
 
const string CARDINALITY = “cardinality”
 Number of unique values in the column(s).
 
const string ESTIMATED_CARDINALITY = “estimated_cardinality”
 Estimate (via hyperloglog technique) of the number of unique values in the column(s).
 
const string PERCENTILE = “percentile”
 Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approximation of the median).
 
const string PERCENTILE_RANK = “percentile_rank”
 Estimate (via t-digest) of the percentile rank of the given value in the column(s) (if the given value is the median of the column(s), percentile_rank(<median>) will return approximately 50.0).
 

​
Detailed Description

A set of string constants for the parameter AggregateStatisticsRequest.stats.

Comma separated list of the statistics to calculate, e.g. “sum,mean”.

Definition at line 77 of file AggregateStatistics.cs.

​
Member Data Documentation

​
◆ CARDINALITY

const string kinetica.AggregateStatisticsRequest.Stats.CARDINALITY = “cardinality”
 static

Number of unique values in the column(s).

Definition at line 116 of file AggregateStatistics.cs.

​
◆ COUNT

const string kinetica.AggregateStatisticsRequest.Stats.COUNT = “count”
 static

Number of objects (independent of the given column(s)).

Definition at line 81 of file AggregateStatistics.cs.

​
◆ ESTIMATED_CARDINALITY

const string kinetica.AggregateStatisticsRequest.Stats.ESTIMATED_CARDINALITY = “estimated_cardinality”
 static

Estimate (via hyperloglog technique) of the number of unique values in the column(s).

Definition at line 120 of file AggregateStatistics.cs.

​
◆ KURTOSIS

const string kinetica.AggregateStatisticsRequest.Stats.KURTOSIS = “kurtosis”
 static

Kurtosis (fourth standardized moment).

Definition at line 99 of file AggregateStatistics.cs.

​
◆ MAX

const string kinetica.AggregateStatisticsRequest.Stats.MAX = “max”
 static

Maximum value of the column(s).

Definition at line 108 of file AggregateStatistics.cs.

​
◆ MEAN

const string kinetica.AggregateStatisticsRequest.Stats.MEAN = “mean”
 static

Arithmetic mean (average), equivalent to sum/count.

Definition at line 85 of file AggregateStatistics.cs.

​
◆ MIN

const string kinetica.AggregateStatisticsRequest.Stats.MIN = “min”
 static

Minimum value of the column(s).

Definition at line 105 of file AggregateStatistics.cs.

​
◆ PERCENTILE

const string kinetica.AggregateStatisticsRequest.Stats.PERCENTILE = “percentile”
 static

Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approximation of the median).

Add a second, comma-separated value to calculate percentile resolution, e.g., ‘percentile(75,150)’.

Definition at line 127 of file AggregateStatistics.cs.

​
◆ PERCENTILE_RANK

const string kinetica.AggregateStatisticsRequest.Stats.PERCENTILE_RANK = “percentile_rank”
 static

Estimate (via t-digest) of the percentile rank of the given value in the column(s) (if the given value is the median of the column(s), percentile_rank(<median>) will return approximately 50.0).

Definition at line 133 of file AggregateStatistics.cs.

​
◆ SKEW

const string kinetica.AggregateStatisticsRequest.Stats.SKEW = “skew”
 static

Skewness (third standardized moment).

Definition at line 96 of file AggregateStatistics.cs.

​
◆ STDV

const string kinetica.AggregateStatisticsRequest.Stats.STDV = “stdv”
 static

Sample standard deviation (denominator is count-1).

Definition at line 89 of file AggregateStatistics.cs.

​
◆ SUM

const string kinetica.AggregateStatisticsRequest.Stats.SUM = “sum”
 static

Sum of all values in the column(s).

Definition at line 102 of file AggregateStatistics.cs.

​
◆ VARIANCE

const string kinetica.AggregateStatisticsRequest.Stats.VARIANCE = “variance”
 static

Unbiased sample variance (denominator is count-1).

Definition at line 93 of file AggregateStatistics.cs.

​
◆ WEIGHTED_AVERAGE

const string kinetica.AggregateStatisticsRequest.Stats.WEIGHTED_AVERAGE = “weighted_average”
 static

Weighted arithmetic mean (using the option WEIGHT_COLUMN_NAME as the weighting column).

Definition at line 113 of file AggregateStatistics.cs.

The documentation for this struct was generated from the following files: