> ## Documentation Index > Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt > Use this file to discover all available pages before exploring further. # kinetica.AggregateStatisticsRequest > kinetica.AggregateStatisticsRequest — Kinetica C# API

A set of parameters for Kinetica.aggregateStatistics. More...

Classes

struct   Options
  A set of string constants for the parameter AggregateStatisticsRequest.options. More...
 
struct   Stats
  A set of string constants for the parameter AggregateStatisticsRequest.stats. More...
 

Public Member Functions

  AggregateStatisticsRequest ()
  Constructs an AggregateStatisticsRequest object with default parameters.
 
  AggregateStatisticsRequest (string table\_name, string column\_name, string stats, IDictionary\< string, string > options=null)
  Constructs an AggregateStatisticsRequest object with the specified parameters.
 
 Public Member Functions inherited from kinetica.KineticaData
  KineticaData (KineticaType type)
  Constructor from Kinetica Type.
 
  KineticaData (System.Type type=null)
  Default constructor, with optional System.Type.
 
object  Get (int fieldPos)
  Retrieve a specific property from this object.
 
void  Put (int fieldPos, object fieldValue)
  Write a specific property to this object.
 

Properties

string  table\_name \[get, set]
  Name of the table on which the statistics operation will be performed, in \[schema\_name.
 
string  column\_name \[get, set]
  Name of the primary column for which the statistics are to be calculated.
 
string  stats \[get, set]
  Comma separated list of the statistics to calculate, e.g.
 
IDictionary\< string, string >  options = new Dictionary\() \[get, set]
  Optional parameters.
 
 Properties inherited from kinetica.KineticaData
Schema  Schema \[get]
  Avro Schema for this class.
 

Additional Inherited Members

 Static Public Member Functions inherited from kinetica.KineticaData
static ? RecordSchema  SchemaFromType (System.Type t, KineticaType? ktype=null)
  Create an Avro Schema from a System.Type and a KineticaType.
 

Detailed Description

A set of parameters for Kinetica.aggregateStatistics.

Calculates the requested statistics of the given column(s) in a given table.

The available statistics are: COUNT (number of total objects), MEAN, STDV (standard deviation), VARIANCE, SKEW, KURTOSIS, SUM, MIN, MAX, WEIGHTED\_AVERAGE, CARDINALITY (unique count), ESTIMATED\_CARDINALITY, PERCENTILE, and PERCENTILE\_RANK.

Estimated cardinality is calculated by using the hyperloglog approximation technique.

Percentiles and percentile ranks are approximate and are calculated using the t-digest algorithm. They must include the desired PERCENTILE/PERCENTILE\_RANK. To compute multiple percentiles each value must be specified separately (i.e. 'percentile(75.0),percentile(99.0),percentile\_rank(1234.56),percentile\_rank(-5)').

A second, comma-separated value can be added to the PERCENTILE statistic to calculate percentile resolution, e.g., a 50th percentile with 200 resolution would be 'percentile(50,200)'.

The weighted average statistic requires a weight column to be specified in WEIGHT\_COLUMN\_NAME. The weighted average is then defined as the sum of the products of AggregateStatisticsRequest.column\_name times the WEIGHT\_COLUMN\_NAME values divided by the sum of the WEIGHT\_COLUMN\_NAME values.

Additional columns can be used in the calculation of statistics via ADDITIONAL\_COLUMN\_NAMES. Values in these columns will be included in the overall aggregate calculation–individual aggregates will not be calculated per additional column. For instance, requesting the COUNT and MEAN of AggregateStatisticsRequest.column\_name x and ADDITIONAL\_COLUMN\_NAMES y and z, where x holds the numbers 1-10, y holds 11-20, and z holds 21-30, would return the total number of x, y, and z values (30), and the single average value across all x, y, and z values (15.5).

The response includes a list of key/value pairs of each statistic requested and its corresponding value.

Definition at line 71 of file AggregateStatistics.cs.

Constructor & Destructor Documentation

◆ AggregateStatisticsRequest() \[1/2]

kinetica.AggregateStatisticsRequest.AggregateStatisticsRequest ( )
inline

Constructs an AggregateStatisticsRequest object with default parameters.

Definition at line 295 of file AggregateStatistics.cs.

◆ AggregateStatisticsRequest() \[2/2]

kinetica.AggregateStatisticsRequest.AggregateStatisticsRequest ( string table\_name,
string column\_name,
string stats,
IDictionary\< string, string > options = null )
inline

Constructs an AggregateStatisticsRequest object with the specified parameters.

Parameters
table\_name Name of the table on which the statistics operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules.
column\_name Name of the primary column for which the statistics are to be calculated.
stats 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(\) will return approximately 50.0).
options Optional parameters.
  • ADDITIONAL\_COLUMN\_NAMES: A list of comma separated column names over which statistics can be accumulated along with the primary column. All columns listed and column\_name must be of the same type. Must not include the column specified in column\_name and no column can be listed twice.
  • WEIGHT\_COLUMN\_NAME: Name of column used as weighting attribute for the weighted average statistic.
The default value is an empty Dictionary.

Definition at line 428 of file AggregateStatistics.cs.

Property Documentation

◆ column\_name

string kinetica.AggregateStatisticsRequest.column\_name
getset

Name of the primary column for which the statistics are to be calculated.

Definition at line 164 of file AggregateStatistics.cs.

◆ options

IDictionary\ kinetica.AggregateStatisticsRequest.options = new Dictionary\()
getset

Optional parameters.

The default value is an empty Dictionary.

Definition at line 291 of file AggregateStatistics.cs.

◆ stats

string kinetica.AggregateStatisticsRequest.stats
getset

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(\) will return approximately 50.0).

Definition at line 266 of file AggregateStatistics.cs.

◆ table\_name

string kinetica.AggregateStatisticsRequest.table\_name
getset

Name of the table on which the statistics operation will be performed, in \[schema\_name.

]table\_name format, using standard name resolution rules.

Definition at line 160 of file AggregateStatistics.cs.

The documentation for this class was generated from the following file:
This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.