RMAX
Window functions
Syntax
RMAX( value [ , direction ] [ TOTAL | WITHIN [ dim1, ... ] | AMONG [ dim1, ... ] ] )
Description
Returns the maximum of all values in a growing (or shrinking) window defined by the sort order and the value of direction:
direction |
Window |
|---|---|
"asc" |
Starts from the first row and ends at the current row. |
"desc" |
Starts from the current row and ends at the last row. |
By default "asc" is used.
Window functions with a similar behavior: RSUM, RCOUNT, RMIN, RAVG.
Argument types:
value—Boolean | Date | Datetime | Number | String | UUIDdirection—String
Return type: Same type as (value)
Note
Only constant values are accepted for arguments (direction).
Warning
Function depends on how data is ordered in the chart. It will work correctly only if:
- data ordering is explicitly specified in the chart;
- result is ordered by all fields that don't use window functions.
Examples
RMAX([Profit])
RMAX([Profit], "asc")
RMAX([Profit] TOTAL)
RMAX([Profit], "desc" WITHIN [Date])
RMAX([Profit] AMONG [Date])
Data source support
Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.