RAVG( value [ , direction ] [ TOTAL | WITHIN [ dim1, ... ] | AMONG [ dim1, ... ] ] )
Returns the average 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.
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.
RAVG([Profit], "desc" WITHIN [Date])
RAVG([Profit] AMONG [Date])
Data source support
Microsoft SQL Server 2017 (14.0),