Aggregation Function Reference

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

Contents

avg — aggregate function to determine the mean average of a field or column.
avgif — aggregate function to return the averagaverage of rows that match the query's predicate.
correlation_coefficient — aggregate function to return the correlation coefficient of two ranges of values.
correlation_coefficientp — aggregate function to return the correlation coefficient of two ranges of values.
count — aggregate function to return the count of rows that match the query's predicate.
count_distinct — aggregate function to return the count of rows in the specified column that have distinct values
countif — aggregate function to return the count of rows that match the query's predicate.
covariance — aggregate function to return the covariance of two ranges of of random values.
covariancep — aggregate function to return the covariance of two ranges of a population of values.
firstval — aggregate function to return the first value from a specified column.
intercept — aggregate function to return the value where a best-fit linear regression line intersects the Y axis.
joinlist — aggregate function to convert an input list to a string with optional separator.
lastval — aggregate function to return the last value from a specified column.
max — aggregate function to return the maximum of a range of values.
min — aggregate function to return the minimum of a range of numeric values.
percentile — aggregate function to return value closest to the specified percentile rank
product — aggregate function to return the cumulative multipication product of a range of values.
slope — aggregate function to the slope of a best-fit linear regression line of two fields.
stdev — aggregate function to return the standard deviation of a range of values.
stdevp — aggregate function to return the population standard deviation of a range of values.
sum — aggregate function to calculate the sum of a range of values.
sumif — aggregate function to return the sum of rows that match the query's predicate.
unique — aggregate function to return a list of the specified number of unique items in the aggregate window.
variance — aggregate function to return the variance of a range of values.
variancep — aggregate function to return the population variance of a range of values.
vwap — aggregate function that returns the volume-weighted average price.