> ## 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.

# AggregateStatisticsByRangeRequest

> AggregateStatisticsByRangeRequest — Kinetica Node.js API

interface AggregateStatisticsByRangeRequest \{\
&#x20;[column\_name](#column_name): string;\
&#x20;[end](#end): number;\
&#x20;[interval](#interval): number;\
&#x20;[options](#options)?: Record\<string, string>;\
&#x20;[select\_expression](#select_expression)?: string;\
&#x20;[start](#start): number;\
&#x20;[stats](#stats): string;\
&#x20;[table\_name](#table_name): string;\
&#x20;[value\_column\_name](#value_column_name): string;\
}

<ul>
  <li>Defined in [src/types.ts:676](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L676)</li>
</ul>

##### Index

### Properties

[column\_name](#column_name) [end](#end) [interval](#interval) [options?](#options) [select\_expression?](#select_expression) [start](#start) [stats](#stats) [table\_name](#table_name) [value\_column\_name](#value_column_name)&#x20;

## Properties

### column\_name

column\_name: string

Name of the binning-column used to divide the set samples into bins.

<ul>
  <li>Defined in [src/types.ts:682](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L682)</li>
</ul>

### end

end: number

The upper bound of the binning-column.

<ul>
  <li>Defined in [src/types.ts:690](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L690)</li>
</ul>

### interval

interval: number

The interval of a bin. Set members fall into bin i if the binning-column falls in the range \[start+intervali, start+interval(i+1)).

<ul>
  <li>Defined in [src/types.ts:692](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L692)</li>
</ul>

### `Optional`options

options?: Record\<string, string>

Optional parameters.

<ul>
  <li>Defined in [src/types.ts:694](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L694)</li>
</ul>

### `Optional`select\_expression

select\_expression?: string

For a non-empty expression statistics are calculated for those records for which the expression is true.

<ul>
  <li>Defined in [src/types.ts:680](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L680)</li>
</ul>

### start

start: number

The lower bound of the binning-column.

<ul>
  <li>Defined in [src/types.ts:688](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L688)</li>
</ul>

### stats

stats: string

A string of comma separated list of the statistics to calculate, e.g. 'sum,mean'. Available statistics: mean, stdv (standard deviation), variance, skew, kurtosis, sum.

<ul>
  <li>Defined in [src/types.ts:686](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L686)</li>
</ul>

### table\_name

table\_name: string

Name of the table on which the ranged-statistics operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules.

<ul>
  <li>Defined in [src/types.ts:678](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L678)</li>
</ul>

### value\_column\_name

value\_column\_name: string

Name of the value-column for which statistics are to be computed.

<ul>
  <li>Defined in [src/types.ts:684](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L684)</li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.