Counts

A Counts chart shows the details of data in a table as a data grid. It gives you numeric summaries of your data, both overall and selected. Learn about each Counts feature below:

Data Sheet: it's a Data Sheet!.

• A Counts view is built from a Data Sheet, so it has all of the behaviors defined for Data Sheets.

Sizes: rows and selection state.

• The top rows give the total number of rows in the data table, and the number of selected and excluded rows. Since all fields are in the same table, these numbers will be the same for each field.

For categorical fields: number of unique values, mode...

• Categorical fields are described by the number of unique values (total and selected) and the mode (most common value), total and selected.

For continuous fields: mean, standard deviation, min, max, and sum.

• Standard descriptive statistics are available: mean, standard deviation, min, max, and sum, for both the complete population and the currently selected subset.

Subsets: you can select subsets of the information.

• You can filter the display to exclude (or include) types of information: simple statistics only, selected subset only.

  From: "Basic View", "Selected Only" properties in the Advanced Chart Properties pane.

Zoombars: Optional scroll and zoom control.

• By default, no Zoombar is displayed, but it can be useful when Basic View and Selected Only are false, so it is available on request.

  From: "Show Zoombar" property in the Advanced Chart Properties pane.

Grid Specification

The layout, labels, and statistics included in a Counts chart can be customized. This is done through the "Grid Specification" property in the Properties pane for the chart (opened from the Advanced Chart Properties button in the chart toolbar).

Grid Example

For this example, the Chart Data Specification lists 4 fields from the MutualFunds table: "# Funds", "3-Year Performance (%)", "Volatility (%)", and "Net Assets ($mm)". (Note that spaces included in field names or labels are preceded by a tilde (~) character, or the full name is enclosed in double-quote marks in the Properties pane.) The Grid Specification property defines 5 rows with 2 columns each: a static label and a statistic calculated from each of the 4 input fields (sum or average of the selected rows). The string "row" in the specification identifies the beginning of a new row in the displayed chart; tokens after that define the contents of successive columns in the chart. The first row is always displayed as a heading.

Statistics are specified like this:

        [1-9].[StatisticName]

The initial number is the index of a field in the "Chart Data Specification" property, shown directly above the "Grid Specification" value. The "StatisticName" tells which statistic should be calculated. Valid choices are:

Statistic Name	Meaning	Applies to type
Rows	Total count of rows in the table, regardless of selection state	Any
Selected	Count of selected rows	Any
Unselected	Count of unselected rows	Any
Excluded	Count of excluded (or filtered) rows	Any
Unique	Count of distinct non-null values in non-excluded rows of the specified field	Any
UniqueSelected	Count of distinct non-null values in selected rows of the specified field	Any
Mode	Most common value in non-excluded rows of the specified field	String
ModeSelected	Most common value in selected rows of the specified field	String
Mean	Average value of non-excluded rows of the specified field	Numeric
MeanSelected	Average value of selected rows of the specified field	Numeric
StdDev	Standard deviation of non-excluded rows of the specified field	Numeric
StdDevSelected	Standard deviation of selected rows of the specified field	Numeric
Min	Minimum value of non-excluded rows of the specified field	Numeric
MinSelected	Minimum value of selected rows of the specified field	Numeric
Max	Maximum value of non-excluded rows of the specified field	Numeric
MaxSelected	Maximum value of selected rows of the specified field	Numeric
Sum	Sum of values of non-excluded rows of the specified field	Numeric
SumSelected	Sum of values of selected rows of the specified field	Numeric

Statistic names must be Capitalized as shown above.

Notice that data can come from up to 9 fields in a single table, and may be laid out in any way you wish: you do not need to put multiple statistics from the same field in a single row or column, and you do not need to lay out the table in the "column per field" layout that is used by the Counts chart by default.

If no "Grid Specification" is given, then standard statistics for each field are displayed in a separate column; the statistics displayed are governed by the "Basic View" and "Selected Only" property settings.

See also:

• Inserting a Counts chart
• Tool bar controls
• Advanced Chart Properties
• Visual Discovery