STAT_RECORD_COUNT

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 record count.

STAT_RECORD_COUNT ( <field_name>[, <from_value>[, <to_value> [, <sample_size>[, <filter_query>]]]] )
  • field_name - can be either a field or table name. If a table name is supplied then only <sample_size> and <filter_query> parameters may be supplied.
  • 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 virtual field at the CUSTOMER level that divides the sum of income by the number of records on the CUSTOMER table.

STAT_SUM ( [CUSTOMER.INCOME]) / STAT_RECORD_COUNT( CUSTOMER )