series_stats_dynamic

The series_stats_dynamic function computes comprehensive statistical measures for a numeric dynamic array (series), returning results in a dynamic object format with named properties. This provides the same statistics as series_stats but with more convenient access through property names instead of array indices.

You can use series_stats_dynamic when you need statistical summaries with easier property-based access, better code readability, or when integrating with other dynamic data structures. This is particularly useful in complex analytical workflows where referring to statistics by name (stats.min, stats.avg) is clearer than using array indices.

Usage

Syntax

series_stats_dynamic(array)

Parameters

Returns

A dynamic object containing the following statistical properties:

Use case examples

['sample-http-logs']
| summarize durations = make_list(req_duration_ms) by id
| extend stats = series_stats_dynamic(durations)
| extend performance_score = 100 - (stats.stdev / stats.avg * 100)
| project id,
    min = stats.min,
    max = stats.max,
    avg = stats.avg,
    performance_score
| take 5

['sample-http-logs']
| summarize durations = make_list(req_duration_ms) by status
| extend stats = series_stats_dynamic(durations)
| extend lower_bound = stats.avg - (2 * stats.stdev)
| extend upper_bound = stats.avg + (2 * stats.stdev)
| extend range_ratio = (stats.max - stats.min) / stats.avg
| project status,
    avg_duration = stats.avg,
    stdev = stats.stdev,
    lower_bound,
    upper_bound,
    range_ratio

List of related functions

• series_stats: Returns the same statistics as a 7-element array instead of a dynamic object with named properties.
• series_max: Compares two arrays element-wise and returns the maximum values.
• series_min: Compares two arrays element-wise and returns the minimum values.
• todynamic: Converts values to dynamic type for custom object construction.

Other query languages