sum_y() | sum_x()

Since 1.3.0

Calculate the sum from a two-dimensional statistical aggregate for the given dimension. For example, sum_y() calculates the skewness for all the values of the y variable, independent of values of the x variable.

Samples

Calculate the sum of the numbers from 0 to 100:

SELECT sum_y(stats_agg(data, data))
  FROM generate_series(0, 100) data;

sum_y
-----
5050

Arguments

The syntax is:

sum_y(
  summary StatsSummary2D
) RETURNS DOUBLE PRECISION

sum_x(
  summary StatsSummary2D
) RETURNS DOUBLE PRECISION

Name	Type	Default	Required	Description
summary	StatsSummary2D	-	✔	The statistical aggregate produced by a stats_agg call

Returns

Column	Type	Description
sum	DOUBLE PRECISION	The sum of the values in the statistical aggregate