RAVG
Window functions
Syntax
RAVG( value [ , direction ] [ TOTAL | WITHIN [ dim1, ... ] | AMONG [ dim1, ... ] ] )
Description
Returns the average 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, RMAX.
Argument types:
value—Numberdirection—String
Return type: Number (whole)
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
RAVG([Profit])
RAVG([Profit], "asc")
RAVG([Profit] TOTAL)
RAVG([Profit], "desc" WITHIN [Date])
RAVG([Profit] AMONG [Date])
Data source support
Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.