bin_auto()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Rounds values down to a fixed-size bin, with control over the bin size and starting point provided by a query property.
Syntax
bin_auto (value)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| value | int, long, real, timespan, or datetime | ✔️ | The value to round into bins. |
To control the bin size and starting point, set the following parameters before using the function.
| Name | Type | Required | Description |
|---|---|---|---|
| query_bin_auto_size | int, long, real, or timespan | ✔️ | Indicates the size of each bin. |
| query_bin_auto_at | int, long, real, or timespan | Indicates one value of value which is a "fixed point" for which bin_auto(fixed_point) == fixed_point. Default is 0. |
Returns
The nearest multiple of query_bin_auto_size below value, shifted so that query_bin_auto_at
will be translated into itself.
Examples
set query_bin_auto_size=1h;
set query_bin_auto_at=datetime(2017-01-01 00:05);
range Timestamp from datetime(2017-01-01 00:05) to datetime(2017-01-01 02:00) step 1m
| summarize count() by bin_auto(Timestamp)
Output
| Timestamp | count_ |
|---|---|
| 2017-01-01 00:05:00.0000000 | 60 |
| 2017-01-01 01:05:00.0000000 | 56 |