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.
A field contains values, loaded from a data source. At a basic level, a field corresponds to a column in a table. Fields are used to create dimensions and measures in visualizations.
Selections are values selected by a user in visualizations in an app used to filter data. When a selection is made, all associated visualizations are updated to reflect the selection. Selections can be saved as bookmarks, and shared with other users.
