FieldValueCount() is an integer function that returns the number of distinct values in a field.
A partial reload can remove values from the data, which will not be reflected in the number returned. The returned number will correspond to all distinct values that were loaded in either the initial reload or any subsequent partial reload.
Syntax:
FieldValueCount(field_name)
Return data type: integer
Arguments:
| Argument | Description |
|---|---|
| field_name | Name of the field for which the value is required. For example, the column in a table. Must be given as a string value. This means that the field name must be enclosed by single quotes. |
Examples and results:
The following examples use the field First name from the table Names.
| Examples | Results |
|---|---|
|
Add the example data to your app and run it. |
The table Names is loaded, as in the sample data. |
|
Chart function: In a table containing the dimension First name, add as a measure: |
|
|
FieldValueCount('First name') |
5 as Peter appears twice. |
|
FieldValueCount('Initials') |
6 as Initials only has distinct values. |
|
Script function: Given the table Names is loaded, as in the example data: |
|
|
FieldCount1: Load FieldValueCount('First name') as MyFieldCount1 Resident Names; |
MyFieldCount1=5, because 'Peter' appears twice. |
|
FieldCount2: Load FieldValueCount('Initials') as MyInitialsCount1 Resident Names; |
MyFieldCount1=6, because 'Initials' only has distinct values. |
Names:
LOAD * inline [
First name|Last name|Initials|Has cellphone
John|Anderson|JA|Yes
Sue|Brown|SB|Yes
Mark|Carr|MC|No
Peter|Devonshire|PD|No
Jane|Elliot|JE|Yes
Peter|Franc|PF|Yes ] (delimiter is '|');
FieldCount1:
Load FieldValueCount('First name') as MyFieldCount1
Resident Names;
FieldCount2:
Load FieldValueCount('Initials') as MyInitialsCount1
Resident Names;