This section lists functions available in earlier versions of Omniscope which have been classified as "deprecated". Although these functions still work, there are now better ways of achieving the same result in more recent versions of Omniscope. These will continue to be supported for the medium term but may be withdrawn from Omniscope after several major releases.
See also: Non-deprecated functions [1] Guide to SUBSET (replacing DATASET) functions [2]
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 [2]. |
The DATASET_... functions (documented in Deprecated Functions [3]) were deprecated as of verson 2.5. New SUBSET functions, in combination with other existing functions, are more flexible and efficient.
See also: Functions Guide [1] Guide to SUBSET functions [2] Deprecated Functions [3]
Links:
[1] http://kb.visokio.com/functions-guide
[2] http://kb.visokio.com/kb/subset-functions
[3] http://kb.visokio.com/kb/functions-guide-deprecated