Edit

Share via


series_sign()

Switch services using the Version drop-down list. Learn more about navigation.
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]