series_asin
This page explains how to use the series_asin function in APL.
The
series_asin function computes the arc sine (inverse sine) of each numeric element in a dynamic array. It returns a new array of the same length, where each element is the arc sine of the corresponding input element. The function is useful when you want to transform time series data or arrays of numeric values into angular measurements. This can help in advanced mathematical modeling, anomaly detection, and when working with normalized data that represents sine values.
You use series_asin when you need to invert sine transformations stored in array form, for example, to reconstruct angular information from periodic signals or normalize log and trace metrics for statistical or geometric analysis.
For users of other query languages
If you come from other query languages, this section explains how to adjust your existing queries to achieve the same results in APL.Splunk SPL users
Splunk SPL users
Splunk SPL doesn’t provide a direct equivalent of
series_asin that operates over arrays. Instead, SPL typically requires you to apply asin() to individual fields or use mvmap to apply the function to multivalue fields. In APL, series_asin simplifies this by applying the operation to each element of a dynamic array in one step.ANSI SQL users
ANSI SQL users
ANSI SQL databases generally provide
ASIN() for scalar values but do not include native array-processing functions. You would need to unnest an array into rows, apply ASIN(), and then aggregate the results back into an array. APL’s series_asin eliminates this boilerplate by letting you compute the arc sine across the entire array at once.Usage
Syntax
Parameters
| Parameter | Type | Description |
|---|---|---|
array | dynamic | A dynamic array of numeric values. Each element should be between -1 and 1, the valid domain of the arc sine function. |
Returns
A dynamic array of the same length as the input, where each element is the arc sine (in radians) of the corresponding input element.Use case examples
When analyzing HTTP logs, you can normalize request durations to the range [-1, 1] and then apply Run in PlaygroundOutput
The query collects request durations per user ID, normalizes them, and applies
series_asin to transform them into angular values for further statistical analysis.Query| id | durations | normalized | angles |
|---|---|---|---|
| A12 | [100, 200, 300, 400, 500] | [0.1, 0.2, 0.3, 0.4, 0.5] | [0.100, 0.201, 0.305, 0.412, 0.524] |
series_asin to transform values into angles.List of related functions
- series_acos: Returns the arc cosine of each element in an array. Use when you need to invert cosine transformations instead of sine.
- series_atan: Returns the arc tangent of each element in an array. Useful for handling tangent-derived data.