boundingRatio

Aggregate function that calculates the slope between the leftmost and rightmost points across a group of values.

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 │
└──────────────────────────────────────────────┘