These functions can only be used in chart expressions.
Field functions either return integers or strings identifying different aspects of field selections.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
GetSelectedCount() finds the number of selected (green) values in a field.
getselectedcount (field_name [, include_excluded])
GetAlternativeCount() is used to find the number of alternative (light gray) values in the identified field.
GetPossibleCount() is used to find the number of possible values in the identified field. If the identified field includes selections, then the selected (green) fields are counted. Otherwise associated (white) values are counted.
GetExcludedCount() finds the number of excluded distinct values in the identified field. Excluded values include alternative (white or light yellow), excluded and selected excluded (gray) fields.
This chart function returns the number of not-selected values in the field named fieldname. The field must be in and-mode for this function to be relevant.
GetNotSelectedCount(fieldname [, includeexcluded=false])
Field and selection functions
GetCurrentField() is used to find the currently active field in the specified group.
GetCurrentSelections() returns the current selections in the document.
getcurrentselections([record_sep [,tag_sep [,value_sep [,max_values]]]])
GetFieldSelections() returns a string with the current selections in a field.
getfieldselections ( field_name [, value_sep [, max_values]])
GetObjectField() returns the name of the dimension. Index is an optional integer denoting the dimension that should be returned.
GetObjectMeasure() returns the name of the measure. Index is an optional integer denoting the measure that should be returned.