GetExcludedCount - chart function

GetExcludedCount() finds the number of excluded distinct values in the identified field. Excluded values include alternative (light gray), excluded (dark gray), and selected excluded (dark gray with check mark) fields.

Syntax:  

GetExcludedCount (field_name)

Return data type: string

Arguments:  

Arguments Description
field_name The field containing the range of data to be measured.

Examples and results:  

The following example uses three fields loaded to different filter panes, one for First name , one for Last name, and one for Initials.

Examples Results

If no values are selected in First name.

GetExcludedCount (Initials) = 0

There are no selections.

If John is selected in First name.

GetExcludedCount (Initials) = 5

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

If John and Peter are selected.

GetExcludedCount (Initials) = 3

John is associated with 1 value and Peter is associated with 2 values, in Initials.

If John and Peter are selected in First name, and then Franc is selected in Last name.

GetExcludedCount ([First name]) = 4

There are 4 excluded values in First name with dark gray color. GetExcludedCount() evaluates for fields with excluded values, including alternative and selected excluded fields.

If John and Peter are selected in First name, and then Franc and Anderson are selected in Last name.

GetExcludedCount (Initials) = 4

There are 4 excluded values in Initials with dark gray color. The other two cells (JA and PF) will be white as they associated with the selections John and Peter in First name.

If John and Peter are selected in First name, and then Franc and Anderson are selected in Last name.

GetExcludedCount ([Last name]) = 4

There are 4 excluded values in Initials. Devonshire has light gray color while Brown, Carr, and Elliot have dark gray color.

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 information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?