This topic provides links to reference descriptions for all the Spotfire 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 average 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.