# timestats¶

Type of operation: Aggregate

## Description¶

Aggregate resource columns at every point in time, based on (optional) grouping columns

## Usage¶

timestats [ groupby ] ..., groupOrAggregateFunction ...


Argument

Type

Required

Multiple

groupby

fieldref

Optional

Can be multiple

groupOrAggregateFunction

expression

Required

Can be multiple

## Accelerable¶

timestats is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs, can be accelerated, making queries on the dataset respond faster.

## Examples¶

timestats Count:count(1), group_by(server_name)


Group input resource by server name, calculating a count of rows for each slice of time per server name, returning a dataset with the 4 columns ‘valid_from’, ‘valid_to’, ‘server_name’, and ‘Count’. As opposed to timechart, this calculates values that change at any point in time, whereas timechart calculates aggregates per fixed bucket.