bin_start_time() -> timestamp

Returns the start time of the current bin (inclusive).

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

Domain

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

Categories

• Time

Examples

timechart 10m, first_to_bin_start:min(timestamp - bin_start_time()), group_by(key)

Create a column named "first_to_bin_start" that contains the difference between the first data point in the bin and the bin's start time.

statsby least_recent:min(timestamp - bin_start_time()), group_by(key)

Return a dataset with two columns "least_recent", and "key" where "least_recent" contains the minimum gap between a row's timestamp and the start of the query window grouped on the "key" column.