Skip to main content
server.Measures Measures over the rows of a group or of a per-parent population.

Type parameters

Methods

count

▸ count(): Measure<"count">

Returns

Measure<"count">

sum

▸ sum<V>(field): Measure<"sum", V> The exact sum, rounded once.

Type parameters

Parameters

Returns

Measure<"sum", V>

decimalSum

▸ decimalSum<V>(field, scale): Measure<"decimal_sum", V> Exact decimal-string sum. The engine rejects rounding or coefficients beyond 38 digits; the result is fixed-scale text, never a JS number.

Type parameters

Parameters

Returns

Measure<"decimal_sum", V>

countDistinct

▸ countDistinct<V>(field): Measure<"count_distinct", V> Counts distinct values, including missing and null as different values.

Type parameters

Parameters

Returns

Measure<"count_distinct", V>

percentile

▸ percentile<V>(field, basisPoints): Measure<"percentile", V> Exact discrete percentile, in integer basis points (5000 is the median). Selects an observed value; it never interpolates or approximates.

Type parameters

Parameters

Returns

Measure<"percentile", V>

decimalPercentile

▸ decimalPercentile<V>(field, basisPoints, scale): Measure<"percentile", V, true> Numeric ordering of decimal strings, with a fixed-scale string result.

Type parameters

Parameters

Returns

Measure<"percentile", V, true>

min

▸ min<V>(field): Measure<"min", V> The least present non-null value, or null. Questions only.

Type parameters

Parameters

Returns

Measure<"min", V>

max

▸ max<V>(field): Measure<"max", V> The greatest present non-null value, or null. Questions only.

Type parameters

Parameters

Returns

Measure<"max", V>

average

▸ average<V>(field, scale): Measure<"average", V> The exact mean of a required integer field as a decimal string with scale (0–18) fraction digits, rounded half to even. Questions only.

Type parameters

Parameters

Returns

Measure<"average", V>