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