Aggregation Functions

1min

Aggregate functions compute a single result from a set of input values. Oxla supports the following functions:
Functions
Description
﻿SUM()﻿
Calculates and returns the sum of all values.
﻿MIN()﻿
Calculates and returns the minimum value.
﻿FOR_MIN()﻿
Calculates and returns a value corresponding to the minimal metric in the same row from a set of values.
﻿MAX()﻿
Calculates and returns the maximum value.
﻿FOR_MAX()﻿
Calculates and Returns a value corresponding to the maximum metric in the same row from a set of values.
﻿AVG()﻿
Calculates and returns the average value.
﻿COUNT()﻿
Counts the number of rows.
﻿BOOL_AND()﻿
Calculates the boolean of all the boolean values in the aggregated group. FALSE if at least one of aggregated rows is FALSE
﻿BOOL_OR()﻿
Calculates the boolean of all the boolean values in the aggregated group. TRUE if at least one of aggregated rows is TRUE.
💡 You can utilize the aggregate functions with the GROUP BY and HAVING clauses in the SELECT statement. 
﻿

Updated 09 Oct 2023

Did this page help you?

POWER

SUM

Functions	Description
SUM()	Calculates and returns the sum of all values.
MIN()	Calculates and returns the minimum value.
FOR_MIN()	Calculates and returns a value corresponding to the minimal metric in the same row from a set of values.
MAX()	Calculates and returns the maximum value.
FOR_MAX()	Calculates and Returns a value corresponding to the maximum metric in the same row from a set of values.
AVG()	Calculates and returns the average value.
COUNT()	Counts the number of rows.
BOOL_AND()	Calculates the boolean of all the boolean values in the aggregated group. FALSE if at least one of aggregated rows is FALSE
BOOL_OR()	Calculates the boolean of all the boolean values in the aggregated group. TRUE if at least one of aggregated rows is TRUE.