bin()
Rounds values down to an integer multiple of a given bin size.
Used frequently in combination with summarize by ...
.
If you have a scattered set of values, they'll be grouped into a smaller set of specific values.
The
bin()
andfloor()
functions are equivalent
Syntax
bin(
value,
roundTo)
Parameters
Name | Type | Required | Description |
---|---|---|---|
value | int, long, real, timespan, or datetime | ✓ | The value to round down. |
roundTo | int, long, real, or timespan | ✓ | The "bin size" that divides value. |
Returns
The nearest multiple of roundTo below value. Null values, a null bin size, or a negative bin size will result in null.
Examples
Expression | Result |
---|---|
bin(4.5, 1) |
4.0 |
bin(time(16d), 7d) |
14d |
bin(datetime(1970-05-11 13:45:07), 1d) |
datetime(1970-05-11) |
The following expression calculates a histogram of durations, with a bucket size of 1 second:
T | summarize Hits=count() by bin(Duration, 1s)