Function | Usage | Description |
| DATASET_EMPTYCOUNT |
DATASET_EMPTYCOUNT(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Number of empty values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_EMPTYCOUNT2 |
DATASET_EMPTYCOUNT2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Number of empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_EMPTYCOUNT3 |
DATASET_EMPTYCOUNT3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Number of empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_EMPTYCOUNT4 |
DATASET_EMPTYCOUNT4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Number of empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_EMPTYCOUNT5 |
DATASET_EMPTYCOUNT5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Number of empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MAX |
DATASET_MAX(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Maximum value (highest or last)] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MAX2 |
DATASET_MAX2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Maximum value (highest or last)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MAX3 |
DATASET_MAX3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Maximum value (highest or last)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MAX4 |
DATASET_MAX4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Maximum value (highest or last)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MAX5 |
DATASET_MAX5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Maximum value (highest or last)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEAN |
DATASET_MEAN(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Mean (average) of values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEAN2 |
DATASET_MEAN2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Mean (average) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEAN3 |
DATASET_MEAN3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Mean (average) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEAN4 |
DATASET_MEAN4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Mean (average) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEAN5 |
DATASET_MEAN5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Mean (average) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEDIAN |
DATASET_MEDIAN(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Median (middle) of values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEDIAN2 |
DATASET_MEDIAN2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Median (middle) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEDIAN3 |
DATASET_MEDIAN3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Median (middle) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEDIAN4 |
DATASET_MEDIAN4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Median (middle) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MEDIAN5 |
DATASET_MEDIAN5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Median (middle) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MIN |
DATASET_MIN(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Minimum value (lowest or first)] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MIN2 |
DATASET_MIN2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Minimum value (lowest or first)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MIN3 |
DATASET_MIN3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Minimum value (lowest or first)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MIN4 |
DATASET_MIN4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Minimum value (lowest or first)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MIN5 |
DATASET_MIN5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Minimum value (lowest or first)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MODE |
DATASET_MODE(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Most common value (first if multimodal)] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MODE2 |
DATASET_MODE2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Most common value (first if multimodal)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MODE3 |
DATASET_MODE3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Most common value (first if multimodal)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MODE4 |
DATASET_MODE4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Most common value (first if multimodal)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_MODE5 |
DATASET_MODE5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Most common value (first if multimodal)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_NONEMPTYCOUNT |
DATASET_NONEMPTYCOUNT(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Number of non-empty values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_NONEMPTYCOUNT2 |
DATASET_NONEMPTYCOUNT2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Number of non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_NONEMPTYCOUNT3 |
DATASET_NONEMPTYCOUNT3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Number of non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_NONEMPTYCOUNT4 |
DATASET_NONEMPTYCOUNT4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Number of non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_NONEMPTYCOUNT5 |
DATASET_NONEMPTYCOUNT5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Number of non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_PRODUCT |
DATASET_PRODUCT(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Product of values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_PRODUCT2 |
DATASET_PRODUCT2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Product of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_PRODUCT3 |
DATASET_PRODUCT3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Product of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_PRODUCT4 |
DATASET_PRODUCT4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Product of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_PRODUCT5 |
DATASET_PRODUCT5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Product of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RANGE |
DATASET_RANGE(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Range of values (maximum minus minimum)] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RANGE2 |
DATASET_RANGE2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Range of values (maximum minus minimum)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RANGE3 |
DATASET_RANGE3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Range of values (maximum minus minimum)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RANGE4 |
DATASET_RANGE4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Range of values (maximum minus minimum)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RANGE5 |
DATASET_RANGE5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Range of values (maximum minus minimum)] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RECORDCOUNT |
DATASET_RECORDCOUNT(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Number of records] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RECORDCOUNT2 |
DATASET_RECORDCOUNT2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Number of records] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RECORDCOUNT3 |
DATASET_RECORDCOUNT3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Number of records] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RECORDCOUNT4 |
DATASET_RECORDCOUNT4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Number of records] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_RECORDCOUNT5 |
DATASET_RECORDCOUNT5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Number of records] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SINGLETON |
DATASET_SINGLETON(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [The single value, if there is one] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SINGLETON2 |
DATASET_SINGLETON2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [The single value, if there is one] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SINGLETON3 |
DATASET_SINGLETON3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [The single value, if there is one] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SINGLETON4 |
DATASET_SINGLETON4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [The single value, if there is one] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SINGLETON5 |
DATASET_SINGLETON5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [The single value, if there is one] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_STDDEV |
DATASET_STDDEV(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Standard deviation of values from the mean] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_STDDEV2 |
DATASET_STDDEV2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Standard deviation of values from the mean] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_STDDEV3 |
DATASET_STDDEV3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Standard deviation of values from the mean] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_STDDEV4 |
DATASET_STDDEV4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Standard deviation of values from the mean] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_STDDEV5 |
DATASET_STDDEV5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Standard deviation of values from the mean] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SUM |
DATASET_SUM(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Sum (total) of values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SUM2 |
DATASET_SUM2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Sum (total) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SUM3 |
DATASET_SUM3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Sum (total) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SUM4 |
DATASET_SUM4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Sum (total) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_SUM5 |
DATASET_SUM5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Sum (total) of values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUECOUNT |
DATASET_UNIQUECOUNT(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [Number of unique non-empty values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUECOUNT2 |
DATASET_UNIQUECOUNT2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [Number of unique non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUECOUNT3 |
DATASET_UNIQUECOUNT3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [Number of unique non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUECOUNT4 |
DATASET_UNIQUECOUNT4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [Number of unique non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUECOUNT5 |
DATASET_UNIQUECOUNT5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [Number of unique non-empty values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUESLIST |
DATASET_UNIQUESLIST(stat_field, subset_field, subset_field_value) |
Calculates the statistical function [A comma-separated list of all unique values] of a field.
Either:
(a) for all records (if only stat_field is specified); or
(b) for a current subset of records (if subset_field is specified); or
(c) for another subset of records (if subset_field and subset_field_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUESLIST2 |
DATASET_UNIQUESLIST2(stat_field, subset_field_1, subset_field_2, subset_field_1_value, subset_field_2_value) |
Calculates the statistical function [A comma-separated list of all unique values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUESLIST3 |
DATASET_UNIQUESLIST3(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_1_value, subset_field_2_value, subset_field_3_value) |
Calculates the statistical function [A comma-separated list of all unique values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUESLIST4 |
DATASET_UNIQUESLIST4(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value) |
Calculates the statistical function [A comma-separated list of all unique values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
| DATASET_UNIQUESLIST5 |
DATASET_UNIQUESLIST5(stat_field, subset_field_1, subset_field_2, subset_field_3, subset_field_4, subset_field_5, subset_field_1_value, subset_field_2_value, subset_field_3_value, subset_field_4_value, subset_field_5_value) |
Calculates the statistical function [A comma-separated list of all unique values] of a field. Either:
(a) for a current subset of records (if subset_field_N is specified); or
(b) for another subset of records (if subset_field_N and subset_field_N_value are specified).
Deprecated - please use the SUBSET family of functions instead. |
SUBSET_RECORDCOUNT
(Omniscope 2.5+) |
SUBSET_RECORDCOUNT(stat_field, subset)
In scripts:
subset_recordCount(stat_field, subset) |
Calculates the statistical function [Number of records] of a field.
Either:
(a) for all records (if only field_name is specified); or
(b) for a subset of data (if subset is specified).
Use the SUBSET function to define a data subset.
Deprecated - please use the RECORDCOUNT function instead.
For more information, please visit SUBSET functions. |
