boundingRatio

Introduced in: v20.1.0 Calculates the slope between the leftmost and rightmost points across a group of values. Syntax

boundingRatio(x, y)

Arguments

x — X-coordinate values. (U)Int* or Float* or Decimal
y — Y-coordinate values. (U)Int* or Float* or Decimal

Returned value Returns the slope of the line between the leftmost and rightmost points, otherwise returns NaN if the data is empty. Float64 Examples Sample data

Query

SELECT
    number,
    number * 1.5
FROM numbers(10)

Response

┌─number─┬─multiply(number, 1.5)─┐
│      0 │                     0 │
│      1 │                   1.5 │
│      2 │                     3 │
│      3 │                   4.5 │
│      4 │                     6 │
│      5 │                   7.5 │
│      6 │                     9 │
│      7 │                  10.5 │
│      8 │                    12 │
│      9 │                  13.5 │
└────────┴───────────────────────┘

Usage example

Query

SELECT boundingRatio(number, number * 1.5)
FROM numbers(10)

Response

┌─boundingRatio(number, multiply(number, 1.5))─┐
│                                          1.5 │
└──────────────────────────────────────────────┘

​boundingRatio

boundingRatio