Aggregation Function Reference

This topic provides links to reference descriptions for all the StreamBase LiveView functions for use in aggregate expressions in tables and queries.

Contents

avg/Avg — Static and dynamic aggregate functions for average (mean)
count/Count — Static and dynamic aggregate functions for count
CountIf — Static aggregate function for count with conditions
firstval — Dynamic aggregate function for firstval
lastval — Dynamic aggregate function for lastval
max/Max — Static and dynamic aggregate functions for max
min/Min — Static and dynamic aggregate functions for min
product — Dynamic aggregate function for products
stdev/Stdev — Static and dynamic aggregate function for standard deviation
StdevIf — Static aggregate function for standard deviation with conditions
stdevp/Stdevp — Static and dynamic aggregate function for population standard deviation
StdevpIf — Static aggregate function for population standard deviation with conditions
sum/Sum — Static and dynamic aggregate functions for sum
SumIf — Static aggregate function for conditional sum
variance — Dynamic aggregate function for variance
variancep — Dynamic aggregate function for population variance
vwap — Dynamic aggregate function for vwap