This function returns the same value for every record in a table. It allows the resultant summary statistic for a field to be compared against each individual value for the field. In this case the summary statistic returned is the maximum value.
STAT_MAXIMUM ( <field_name>[, <from_value>[, <to_value> [, <sample_size>[,<filter_query>]]]] )
-
field_name: The name of the field to calculate the statistic on.
-
from_value: The lowest value for the field to include in the calculation of the statistic. The default is the minimum value in the field.
-
to_value: The highest value for the field to include in the calculation of the statistic. The default is the maximum value in the field.
-
sample_size: A number representing the number of records to include. Can be 1, 10, 100 or 1000. The default is 1.
-
filter_query: A query string representing the domain of records to calculate the statistic for.
Example: Create a query at the CUSTOMER level to return customers whose income is more than 5000 below the maximum income of female customers.
[CUSTOMER.INCOME] < STAT_MAXIMUM( [CUSTOMER.INCOME],,,,[CUSTOMER.GENDER] = "Female")-5000