| Syntax | ATTR(expression) |
| Definition | Returns the value of the expression if it has a single value for all rows. Otherwise returns an asterisk. Null values are ignored. |
| Syntax | AVG(expression) |
| Definition | Returns the average of all the values in the expression. Null values are ignored. |
| Notes | AVG can only be used with numeric fields. |
| Syntax | COLLECT(spatial) |
| Definition | An aggregate calculation that combines the values in the argument field. Null values are ignored. |
| Notes | COLLECT can only be used with spatial fields. |
| Syntax | CORR(expression1, expression2)
|
| Output | Number from -1 to 1 |
| Definition | Returns the Pearson correlation coefficient of two expressions. |
| Example | example |
| Notes |
The Pearson correlation measures the linear relationship between two variables. Results range from -1 to +1 inclusive, where 1 denotes an exact positive linear relationship, 0 denotes no linear relationship between the variance, and −1 is an exact negative relationship. The square of a CORR result is equivalent to the R-Squared value for a linear trend line model. See Trend Line Model Terms. Use with table scoped LOD expressions: You can use CORR to visualize correlation in a disaggregated scatter using a table-scoped level of detail expression. For example: {CORR(Sales, Profit)}
With a level of detail expression, the correlation is run over all rows. If you used a formula like |
| Database limitations |
For other data sources, consider either extracting the data or using |
| Syntax | COUNT(expression) |
| Definition | Returns the number of items. Null values are not counted. |
| Syntax | COUNTD(expression) |
| Definition | Returns the number of distinct items in a group. Null values are not counted. |
| Syntax | COVAR(expression1, expression2)
|
| Definition | Returns the sample covariance of two expressions. |
| Notes |
Covariance quantifies how two variables change together. A positive covariance indicates that the variables tend to move in the same direction, as when larger values of one variable tend to correspond to larger values of the other variable, on average. Sample covariance uses the number of non-null data points n - 1 to normalize the covariance calculation, rather than n, which is used by the population covariance (available with the If The value of |
| Database limitations |
For other data sources, consider either extracting the data or using |
| Syntax | COVARP(expression 1, expression2)
|
| Definition | Returns the population covariance of two expressions. |
| Notes |
Covariance quantifies how two variables change together. A positive covariance indicates that the variables tend to move in the same direction, as when larger values of one variable tend to correspond to larger values of the other variable, on average. Population covariance is sample covariance multiplied by (n-1)/n, where n is the total number of non-null data points. Population covariance is the appropriate choice when there is data available for all items of interest as opposed to when there is only a random subset of items, in which case sample covariance (with the If |
| Database limitations |
For other data sources, consider either extracting the data or using |
| Syntax | MAX(expression) or MAX(expr1, expr2) |
| Output | Same data type as the argument, or NULL if any part of the argument is null. |
| Definition |
Returns the maximum of the two arguments, which must be of the same data type.
|
| Example | MAX(4,7) = 7 |
| Notes |
For strings
For database data sources, the For dates For dates, the As an aggregation
As a comparison
See also |
| Syntax | MEDIAN(expression)
|
| Definition | Returns the median of an expression across all records. Null values are ignored. |
| Notes | MEDIAN can only be used with numeric fields. |
| Database limitations |
For other data source types, you can extract your data into an extract file to use this function. See Extract Your Data. |
| Syntax | MIN(expression) or MIN(expr1, expr2) |
| Output | Same data type as the argument, or NULL if any part of the argument is null. |
| Definition |
Returns the minimum of the two arguments, which must be of the same data type.
|
| Example | MIN(4,7) = 4 |
| Notes |
For strings
For database data sources, the For dates For dates, the As an aggregation
As a comparison
See also |
| Syntax | PERCENTILE(expression, number)
|
| Definition | Returns the percentile value from the given expression corresponding to the specified <number>. The <number> must be between 0 and 1 (inclusive) and must be a numeric constant. |
| Example | PERCENTILE([Score], 0.9) |
| Database limitations |
This function is available for the following data sources: Non-legacy Microsoft Excel and Text File connections, Extracts and extract-only data source types (for example, Google Analytics, OData, or Salesforce), Sybase IQ 15.1 and later data sources, Oracle 10 and later data sources, Cloudera Hive and Hortonworks Hadoop Hive data sources, EXASolution 4.2 and later data sources. For other data source types, you can extract your data into an extract file to use this function. See Extract Your Data. |
| Syntax | STDEV(expression) |
| Definition | Returns the statistical standard deviation of all values in the given expression based on a sample of the population. |
| Syntax | STDEVP(expression) |
| Definition | Returns the statistical standard deviation of all values in the given expression based on a biased population. |
| Syntax | SUM(expression) |
| Definition | Returns the sum of all values in the expression. Null values are ignored. |
| Notes | SUM can only be used with numeric fields. |
| Syntax | VAR(expression) |
| Definition | Returns the statistical variance of all values in the given expression based on a sample of the population. |
| Syntax | VARP(expression) |
| Definition | Returns the statistical variance of all values in the given expression on the entire population. |