FieldValueCount - script and chart function
FieldValueCount() is an integer function that finds the number of distinct values in a field.
Syntax:
FieldValueCount(field_name)
Arguments:
Argument | Description |
---|---|
field_name | Name of the field for which the value is required. Must be given as a string value. This means that the field name must be enclosed by single quotes. |
Examples and results:
The following example uses two fields: First name and Initials.
Examples | Results |
---|---|
FieldValueCount('First name') |
5 as Peter appears twice. |
FieldValueCount('Initials') |
6 as Initials only has distinct values. |
Data used in example:
First name | Initials |
---|---|
John | JA |
Sue | SB |
Mark | MC |
Peter | PD |
Jane | JE |
Peter | PF |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!