Edit

Share via

series_add()

  • Article

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Calculates the element-wise addition of two numeric series inputs.

Syntax

series_add(series1, series2)

Learn more about syntax conventions.

Parameters

Name Type Required Description
series1, series2 dynamic ✔️ The numeric arrays to be element-wise added into a dynamic array result.

Returns

Dynamic array of calculated element-wise add operation between the two inputs. Any non-numeric element or non-existing element (arrays of different sizes) yields a null element value.

Example

range x from 1 to 3 step 1
| extend y = x * 2
| extend z = y * 2
| project s1 = pack_array(x,y,z), s2 = pack_array(z, y, x)
| extend s1_add_s2 = series_add(s1, s2)

Output

s1 s2 s1_add_s2
[1,2,4] [4,2,1] [5,4,5]
[2,4,8] [8,4,2] [10,8,10]
[3,6,12] [12,6,3] [15,12,15]