min() (aggregation function)
Finds the minimum value across the group.
Note
This function is used in conjunction with the summarize operator.
Syntax
min
(
expr)
Learn more about syntax conventions.
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. If you want to see other columns in addition to the min, use arg_min.
Example
This example returns the first record in a table.
StormEvents
| summarize FirstEvent=min(StartTime)
Output
FirstEvent |
---|
2007-01-01T00:00:00Z |
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for