min() (aggregation function)
Finds the minimum value across the group.
Note
This function is used in conjunction with the summarize operator.
Syntax
min (expr)
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| expr | string | ✓ | The expression used for the minimum value aggregation calculation. |
Returns
Returns the minimum value of expr across the group.
Tip
This gives you the min on its own. But if you want other columns in the row arg_min.
Example
This example returns the first record in a table.
StormEvents
| summarize FirstEvent=min(StartTime)
Output
| FirstEvent |
|---|
| 2007-01-01T00:00:00Z |