series_sign()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Calculates the element-wise sign of the numeric series input.
Syntax
series_sign(series)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| series | dynamic |
✔️ | An array of numeric values over which the sign function is applied. |
Returns
A dynamic array of calculated sign function values. -1 for negative, 0 for 0, and 1 for positive. Any non-numeric element yields a null element value.
Example
print arr = dynamic([-6, 0, 8])
| extend arr_sign = series_sign(arr)
Output
| arr | arr_sign |
|---|---|
| [-6,0,8] | [-1,0,1] |