MongoDB · Types · Queries

ArxAggregateOperator

Definition

Namespace
ARX.SDK.Query
Package
ARX.SDK
C#
public enum ArxAggregateOperator

The value an aggregate column computes: a count, the minimum, maximum, sum or average, a standard deviation or a variance.

Values

None= 0

No aggregate.

Count= 1

The number of rows (or of non-null values of the attribute).

CountDistinct= 2

The number of distinct non-null values.

CountBig= 3

As Count, as a 64-bit number where the database distinguishes it.

CountBigDistinct= 4

As CountDistinct, as a 64-bit number where the database distinguishes it.

Min= 5

The smallest value.

Max= 6

The largest value.

Sum= 7

The sum of the values.

Avg= 8

The average of the values.

StDev= 9

The sample standard deviation.

StDevP= 10

The population standard deviation.

Var= 11

The sample variance.

VarP= 12

The population variance.

Usage

C#

A line from a verified sample; the full, runnable code is on its page.

query.AggregateInfo.AddAggregateColumn("accounts", "", ArxAggregateOperator.Count);

A report by industry, scenario 1

Used in: