bin_size¶

Description¶

Returns the size of the time bin that’s being aggregated.

Typically used with time binning verbs timechart or align. When used with statsby returns the query window size.

duration

This is a scalar function (calculates a single output value for a single input row.)

bin_size()

timechart 10m, bin_size: bin_size(), group_by()

Create a column named “bin_size” that contains the size of the bin that timechart is aggregating upon. In this case, it should always be 10 minutes.

timechart 5m, frame(back: 20m), bin_size: bin_size(), group_by()

Create a column named “bin_size” that contains the size of the bin that timechart is aggregating upon. In this case, it should always be 20 minutes.

timechart events_per_minute: count() / to_minutes(bin_size()), group_by()

Create a column named “events_per_minute” that shows the average number of events per minute.

statsby events_per_minute: count() / to_minutes(bin_size()), group_by()

Return a dataset with column “events_per_minute” that calculates the number of rows per minute over the entire query window.