STAT_IQ_RANGE

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 inter-quartile range.

STAT_IQ_RANGE ( <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 Individual level to return all individuals whose income is more than the interquartile range of income for female individuals, considering all income values ranging from the minimum to the maximum value.

[Individual.INCOME] > STAT_IQ_RANGE ( [Individual.INCOME], , , , [Individual.Gender Bands] = "Female" )