|
Kinetica C# API
Version 6.0.1.0
|
|
Kinetica C# API
Version 6.0.1.0
|
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... | |
Comma separated list of the statistics to calculate, e.g.
"sum,mean". Values: count, mean, stdv, variance, skew, kurtosis, sum, min, max, weighted_average, cardinality, estimated_cardinality, percentile, percentile_rank.
A set of string constants for the parameter <member name="stats">.
Definition at line 63 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.CARDINALITY = "cardinality" |
Number of unique values in the column(s).
Definition at line 102 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.COUNT = "count" |
Number of objects (independent of the given column(s)).
Definition at line 68 of file AggregateStatistics.cs.
| 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 106 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.KURTOSIS = "kurtosis" |
Kurtosis (fourth standardized moment).
Definition at line 86 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.MAX = "max" |
Maximum value of the column(s).
Definition at line 95 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.MEAN = "mean" |
Arithmetic mean (average), equivalent to sum/count.
Definition at line 72 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.MIN = "min" |
Minimum value of the column(s).
Definition at line 92 of file AggregateStatistics.cs.
| 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).
Definition at line 111 of file AggregateStatistics.cs.
| 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 117 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.SKEW = "skew" |
Skewness (third standardized moment).
Definition at line 83 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.STDV = "stdv" |
Sample standard deviation (denominator is count-1).
Definition at line 76 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.SUM = "sum" |
Sum of all values in the column(s).
Definition at line 89 of file AggregateStatistics.cs.
| const string kinetica.AggregateStatisticsRequest.Stats.VARIANCE = "variance" |
Unbiased sample variance (denominator is count-1).
Definition at line 80 of file AggregateStatistics.cs.
| 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 99 of file AggregateStatistics.cs.
1.8.5 
