bin_size() -> duration

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.

Domain

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

Categories

Examples

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.

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.

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

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