deltaSum

Sums the arithmetic difference between consecutive rows. If the difference is negative, it is ignored.

Note

The underlying data must be sorted for this function to work properly. If you would like to use this function in a materialized view, you most likely want to use the deltaSumTimestamp method instead.

Syntax

deltaSum(value)

Arguments

value — Input values, must be Integer or Float type.

Returned value

A gained arithmetic difference of the Integer or Float type.

Examples

Query:

SELECT deltaSum(arrayJoin([1, 2, 3]));

Result:

┌─deltaSum(arrayJoin([1, 2, 3]))─┐
│                              2 │
└────────────────────────────────┘

Query:

SELECT deltaSum(arrayJoin([1, 2, 3, 0, 3, 4, 2, 3]));

Result:

┌─deltaSum(arrayJoin([1, 2, 3, 0, 3, 4, 2, 3]))─┐
│                                             7 │
└───────────────────────────────────────────────┘

Query:

SELECT deltaSum(arrayJoin([2.25, 3, 4.5]));

Result:

┌─deltaSum(arrayJoin([2.25, 3, 4.5]))─┐
│                                2.25 │
└─────────────────────────────────────┘

deltaSum

Introduced in: v21.3

Sums the arithmetic difference between consecutive rows. If the difference is negative, it is ignored.

Tip

The underlying data must be sorted for this function to work properly. If you would like to use this function in a materialized view, you most likely want to use the deltaSumTimestamp function instead.

See also:

runningDifference

Syntax

deltaSum(x1[, x2, ...])

Arguments

x1[, x2, ...] — One or more input values. Integer or Float

Returned value

Returns a gained arithmetic difference of the input values. (U)Int* or Float*

Examples

Basic usage with positive differences

SELECT deltaSum(arrayJoin([1, 2, 3]))

┌─deltaSum(arrayJoin([1, 2, 3]))─┐
│                              2 │
└────────────────────────────────┘

Mixed values with negative differences ignored

SELECT deltaSum(arrayJoin([1, 2, 3, 0, 3, 4, 2, 3]))

┌─deltaSum(arrayJoin([1, 2, 3, 0, 3, 4, 2, 3]))─┐
│                                             7 │
└───────────────────────────────────────────────┘

Float values

SELECT deltaSum(arrayJoin([2.25, 3, 4.5]))

┌─deltaSum(arrayJoin([2.25, 3, 4.5]))─┐
│                                2.25 │
└─────────────────────────────────────┘

See Also​

deltaSum​

See Also

deltaSum