series_min
This page explains how to use the series_min function in APL.
The series_min function compares two numeric arrays element by element and returns a new array. Each position in the result contains the minimum value between the corresponding elements from the two input arrays.
You use series_min when you want to create a lower bound from multiple series, combine baseline metrics with actual values while keeping the smaller value, or merge data from different sources by selecting the lower value at each point. For example, you can compare response times across different servers and keep the lower value at each time point, or create minimum thresholds from multiple sources.
Usage
Syntax
Parameters
| Parameter | Type | Description |
|---|---|---|
array1 | array | The first array of numeric values. |
array2 | array | The second array of numeric values. Must have the same length as array1. |
Returns
An array of numeric values. Each element is the minimum of the corresponding elements from array1 and array2.
Use case examples
You want to create a lower bound by comparing request durations across two different cities and keeping the lower value at each time point.
Query
Output
| london_avg | paris_avg | min_duration |
|---|---|---|
| [120, 150, 100] | [180, 130, 190] | [120, 130, 100] |
This query compares response times between two cities and creates a series containing the lower value at each time point.
You want to track the minimum count between successful and failed requests at each time point to identify which type has less traffic.
Query
Output
| success_count | failure_count | min_count |
|---|---|---|
| [300, 280, 310] | [10, 290, 15] | [10, 280, 15] |
This query compares success and failure counts and returns the lower value at each time point, helping you identify the minority traffic pattern.
List of related functions
- series_max: Compares two arrays and returns the maximum value at each position.
- series_less: Compares two arrays and returns
truewhere elements in the first array are less than the second. - series_greater: Compares two arrays and returns
truewhere the first array element is greater than the second. - min: Aggregation function that returns the minimum value across grouped records.