Skip to main content

FieldValueCount - script and chart function

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:  

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 and results
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.
Data used in examples:
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;

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!