Visokio DATASET Functions

This section documents the Visokio-specific DATASET functions currently available in Visokio applications:

DATASET_EMPTYCOUNT
DATASET_EMPTYCOUNT(field_name, category_field, category_field_value)
Calculates the statistical function [Number of empty values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_NONEMPTYCOUNT
DATASET_NONEMPTYCOUNT(field_name, category_field, category_field_value)
Calculates the statistical function [Number of non-empty values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_UNIQUECOUNT
DATASET_UNIQUECOUNT(field_name, category_field, category_field_value)
Calculates the statistical function [Number of unique non-empty values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MEAN
DATASET_MEAN(field_name, category_field, category_field_value)
Calculates the statistical function [Mean (average) of values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MEDIAN
DATASET_MEDIAN(field_name, category_field, category_field_value)
Calculates the statistical function [Median (middle) of values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MIN
DATASET_MIN(field_name, category_field, category_field_value)
Calculates the statistical function [Minimum value (lowest or first)] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_MAX
DATASET_MAX(field_name, category_field, category_field_value)
Calculates the statistical function [Maximum value (highest or last)] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_RANGE
DATASET_RANGE(field_name, category_field, category_field_value)
Calculates the statistical function [Range of values (maximum minus minimum)] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_SUM
DATASET_SUM(field_name, category_field, category_field_value)
Calculates the statistical function [Sum (total) of values] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

DATASET_STDDEV
DATASET_STDDEV(field_name, category_field, category_field_value)
Calculates the statistical function [Standard deviation of values from the mean] of a field: either
(a) for all records (if only field_name is specified); or
(b) for a current subset of records (if category_field is specified); or
(c) for another subset of records (if category_field and category_field_value are specified):
Do not select field_name from drop down, instead type field_name and put it in quotes

----------------------------------

We have also added DATASET_SUM2, DATASET_SUM3, DATASET_SUM4 and DATASET_SUM5, so (unrelated to aggregation in the table), for each record, you can now calculate the sum (or mean, etc.) of a field for all records in the same group of records specified by up to 5 field intersections.

So, as per DATASET_SUM (or DATASET_MEAN, etc), where you could find the SUM (or MEAN, etc) of a field for all records with the same [Month] value, now you can find the SUM (or MEAN, etc) for all records with the same [Month][Client] values using DATASET_SUM2, or with the same [Month][Client][Currency Pair] values using DATASET_SUM3.