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.