Summary Functions
 |  |  |  |
 |
| |||||||||
 |
| ||
The arguments to summary functions are fields from the report or the data source. These functions gather statistics and summarize data values. Some functions allow an array of values to be passed to a summarization function. These functions are often used with groups.
Average({table.field}) Returns the average for the given field value for however many records were processed in the Details section. This function can also accept the name of an array in place of the {table.field} argument.
Correlation Returns a number that represents how well the variation of one value can be predicted from the variation of another.
Count Returns the number of occurrences of a field. This function can also accept the name of an array in place of the {table.field} argument.
Covariance Returns a number that represents the tendency of two variables to move in tandem to one another.
DistinctCount Returns the number of unique occurrences of a value in a field. This function can also accept the name of an array in place of the {table.field} argument.
Maximum Returns the maximum value in a set of values (e.g., all the records for a given field). This function can also accept the name of an array in place of the {table.field} argument.
Median Returns the middle number in a set of values by dividing numerically ordered data into two equal parts.
Minimum Returns the minimum value in a set of values (e.g., all the records for a given field). This function can also accept the name of an array in place of the {table.field} argument.
Mode Returns the data value that occurred the most often in the set of values.
NthLargest Where N is any positive integer, returns the N largest data values.
NthMostFrequent Where N is any positive integer, returns the N most frequently occurring data value.
NthSmallest Where N is any positive integer, returns the N smallest data values.
PercentOfAverage Returns the average of values in a group relative to the percentage of all values.
PercentOfCount Returns the count of values in a group relative to the count of all values.
PercentOfDistinctCount Returns the count of distinct values in a group relative to the count of all distinct values.
PercentOfMaximum Returns the maximum of values in a group relative to the maximum of all values.
PercentOfMinimum Returns the minimum of values in a group relative to the minimum of all values.
PercentOfSum Returns the sum of values in a group relative to the sum of all values.
Population Variance Returns a number representing the dispersion in the values of a given population of data.
PopulationStdDev This function can also accept the name of an array in place of the {table.field} argument.
PthPercentile Returns the value associated with the specified percentile for the given field.
StdDev Standard deviation measures the spread of a distribution about the mean in a set of data values. This function can also accept the name of an array in place of the {table.field} argument.
Sum Adds the values in a field or set of values. This function can also accept the name of an array in place of the {table.field} argument.
Variance Returns a number measuring the amount of change between values in a set of data. This function can also accept the name of an array in place of the {table.field} argument.
WeightedAverage Returns an average that accounts for a dependent variable.
| ||
 | |
| Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement | |
| Conello © 2000-2003 Feedback | |
EAN: 2147483647
Pages: 217