min() (aggregation function)

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

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