Skip to main content

GetExcludedCount - chart function

GetExcludedCount() finds the number of excluded (dark gray) values in the identified field.

Syntax:  

GetExcludedCount (field_name)

Return data type: string

Limitations:  

GetExcludedCount() only evaluates for fields with associated values, that is, fields without selections. For fields with selections GetExcludedCount() will return 0.

Arguments:  

Arguments Description
field_name 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.

GetExcludedCount ([Initials])

5 as there are 5 excluded (gray) values in Initials. The sixth cell (JA) will be white as it is associated with the selection John in First name.

Given that John and Peter are selected.

GetExcludedCount ([Initials])

3 as Peter is associated with 2 values in Initials.

Given that no values are selected in First name.

GetExcludedCount ([Initials])

0 as there are no selections.

Given that John is selected in First name.

GetExcludedCount ([First name])

0 as GetExcludedCount() only evaluates for fields with associated values, that is, fields without selections.

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 '|');

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!