FIRST( value [ TOTAL | WITHIN ... | AMONG ... ] [ ORDER BY ... ] [ BEFORE FILTER BY ... ] )
The sorting order is based on the fields listed in the sorting section of the chart and in the
ORDER BY clause. First,
ORDER BY fields are used, and then they are complemented by the fields from the chart.
Returns the value of
value from the first row in the window. See also LAST.
Return type: Same type as (
FIRST(SUM([Sales]) WITHIN [Month] ORDER BY [Date])
Data source support
Microsoft SQL Server 2017 (14.0),
Oracle Database 12c (12.1),