Skip to main content

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

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 β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

See Also​