Comma separated list of the statistics to calculate, e.g. More...

Public Attributes
const string	COUNT = "count"
	Number of objects (independent of the given column(s)). More...

const string	MEAN = "mean"
	Arithmetic mean (average), equivalent to sum/count. More...

const string	STDV = "stdv"
	Sample standard deviation (denominator is count-1). More...

const string	VARIANCE = "variance"
	Unbiased sample variance (denominator is count-1). More...

const string	SKEW = "skew"
	Skewness (third standardized moment). More...

const string	KURTOSIS = "kurtosis"
	Kurtosis (fourth standardized moment). More...

const string	SUM = "sum"
	Sum of all values in the column(s). More...

const string	MIN = "min"
	Minimum value of the column(s). More...

const string	MAX = "max"
	Maximum value of the column(s). More...

const string	WEIGHTED_AVERAGE = "weighted_average"
	Weighted arithmetic mean (using the option weight_column_name as the weighting column). More...

const string	CARDINALITY = "cardinality"
	Number of unique values in the column(s). More...

const string	ESTIMATED_CARDINALITY = "estimated_cardinality"
	Estimate (via hyperloglog technique) of the number of unique values in the column(s). More...

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). More...

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). More...

Detailed Description

Comma separated list of the statistics to calculate, e.g.

"sum,mean". Supported values:

COUNT: Number of objects (independent of the given column(s)).
MEAN: Arithmetic mean (average), equivalent to sum/count.
STDV: Sample standard deviation (denominator is count-1).
VARIANCE: Unbiased sample variance (denominator is count-1).
SKEW: Skewness (third standardized moment).
KURTOSIS: Kurtosis (fourth standardized moment).
SUM: Sum of all values in the column(s).
MIN: Minimum value of the column(s).
MAX: Maximum value of the column(s).
WEIGHTED_AVERAGE: Weighted arithmetic mean (using the option weight_column_name as the weighting column).
CARDINALITY: Number of unique values in the column(s).
ESTIMATED_CARDINALITY: Estimate (via hyperloglog technique) of the number of unique values in the column(s).
PERCENTILE: 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)'
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).

A set of string constants for the parameter stats.

Definition at line 156 of file AggregateStatistics.cs.

Member Data Documentation

◆ CARDINALITY

const string kinetica.AggregateStatisticsRequest.Stats.CARDINALITY = "cardinality"

Number of unique values in the column(s).

Definition at line 195 of file AggregateStatistics.cs.

◆ COUNT

const string kinetica.AggregateStatisticsRequest.Stats.COUNT = "count"

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

Definition at line 161 of file AggregateStatistics.cs.

◆ ESTIMATED_CARDINALITY

const string kinetica.AggregateStatisticsRequest.Stats.ESTIMATED_CARDINALITY = "estimated_cardinality"

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

Definition at line 199 of file AggregateStatistics.cs.

◆ KURTOSIS

const string kinetica.AggregateStatisticsRequest.Stats.KURTOSIS = "kurtosis"

Kurtosis (fourth standardized moment).

Definition at line 179 of file AggregateStatistics.cs.

◆ MAX

const string kinetica.AggregateStatisticsRequest.Stats.MAX = "max"

Maximum value of the column(s).

Definition at line 188 of file AggregateStatistics.cs.

◆ MEAN

const string kinetica.AggregateStatisticsRequest.Stats.MEAN = "mean"

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

Definition at line 165 of file AggregateStatistics.cs.

◆ MIN

const string kinetica.AggregateStatisticsRequest.Stats.MIN = "min"

Minimum value of the column(s).

Definition at line 185 of file AggregateStatistics.cs.

◆ PERCENTILE

const string kinetica.AggregateStatisticsRequest.Stats.PERCENTILE = "percentile"

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 205 of file AggregateStatistics.cs.

◆ PERCENTILE_RANK

const string kinetica.AggregateStatisticsRequest.Stats.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).

Definition at line 211 of file AggregateStatistics.cs.

◆ SKEW

const string kinetica.AggregateStatisticsRequest.Stats.SKEW = "skew"

Skewness (third standardized moment).

Definition at line 176 of file AggregateStatistics.cs.

◆ STDV

const string kinetica.AggregateStatisticsRequest.Stats.STDV = "stdv"

Sample standard deviation (denominator is count-1).

Definition at line 169 of file AggregateStatistics.cs.

◆ SUM

const string kinetica.AggregateStatisticsRequest.Stats.SUM = "sum"

Sum of all values in the column(s).

Definition at line 182 of file AggregateStatistics.cs.

◆ VARIANCE

const string kinetica.AggregateStatisticsRequest.Stats.VARIANCE = "variance"

Unbiased sample variance (denominator is count-1).

Definition at line 173 of file AggregateStatistics.cs.

◆ WEIGHTED_AVERAGE

const string kinetica.AggregateStatisticsRequest.Stats.WEIGHTED_AVERAGE = "weighted_average"

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

Definition at line 192 of file AggregateStatistics.cs.

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

Kinetica/Protocol/AggregateStatistics.cs

Public Attributes