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.
Count functions
GetAlternativeCount()is used to find the number of alternative (light gray) values in the identified field.
GetExcludedCount() finds the number of excluded distinct values in the identified field. Only excluded (dark gray) fields are counted. Alternative (light gray) and selected excluded (dark gray with check mark) values are not counted.
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.
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.
GetCurrentSelections() returns a list of the current selections in the app. If the selections are instead made using a search string in a search box, GetCurrentSelections() returns the search string.
