GetPossibleCount - chart function
For fields with selections, GetPossibleCount() returns the number of selected (green) fields.
Return data type: integer
Syntax:
GetPossibleCount (field_name)
Arguments:
| Arguments | Description |
|---|---|
|
|
The field containing the range of data to be measured. |
Examples and results:
The following example uses two fields loaded to different filter panes, one for First name name and one for Initials.
| Examples | Results |
|---|---|
|
Given that John is selected in First name. GetPossibleCount ([Initials]) |
1 as there is 1 value in Initials associated with the selection, John, in First name. |
|
Given that John is selected in First name. GetPossibleCount ([First name]) |
1 as there is 1 selection, |
|
Given that Peteris selected in First name. GetPossibleCount ([Initials]) |
2 as Peter is associated with 2 values in Initials. |
|
Given that no values are selected in First name. GetPossibleCount ([First name]) |
5 as there are no selections and there are 5 unique values in First name. |
|
Given that no values are selected in First name. GetPossibleCount ([Initials]) |
6 as there are no selections and there are 6 unique values in Initials. |
Data used in example:
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 '|');
