RMAX( value [ , direction ] [ TOTAL | WITHIN [ dim1, ... ] | AMONG [ dim1, ... ] ] )
Returns the maximum of all values in a growing (or shrinking) window defined by the sort order and the value of
||Starts from the first row and ends at the current row.|
||Starts from the current row and ends at the last row.|
"asc" is used.
Boolean | Date | Datetime | Number | String | UUID
Return type: Same type as (
Only constant values are accepted for arguments (direction).
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.
RMAX([Profit], "desc" WITHIN [Date])
RMAX([Profit] AMONG [Date])
Data source support
Microsoft SQL Server 2017 (14.0),