Reference: |
A count provides a statistical summary of a data table and lists exact numerical values for data fields within the table in an easy-to-read, textual format. Counts should be used when specific information (for example, mean, standard deviation, minimum, maximum, or most common value) is needed for either an entire table or a selected subset of that table. They can include selected or deleted records, total records, and miscellaneous statistics.
The following image shows an example of a count.
Counts that are created using WebFOCUS Visual Discovery can display data in these formats:
The counts component is typically used with other data visualization components.
Note: You can only see summary statistics in counts. You cannot select items in this component. The count items update as you select data in the other visualization components on a dashboard. When selections are made in other components however, counts are updated.
Label |
Description |
---|---|
Count |
The total number of all items. |
Deleted |
The total number of excluded items. |
Max |
The largest value of any item. |
Max Sel |
The largest value of any of the selected items. |
Mean |
The mean of all items. |
Mean Sel |
The mean of the selected items. |
Min |
The smallest value of any item. |
Min Sel |
The smallest value of any selected item. |
Mode |
The value with the most items. |
Mode Sel |
The value with the most selected items. |
Selected |
The total number of selected items. |
Sum Sel |
The sum of all of the selected items. |
Std Dev |
The standard deviation for all items. |
Std Sel |
The standard deviation for selected items. |
Sum |
The sum of all items. |
Unique |
The number of unique values. |
Uniq Sel |
The number of unique values for selected items. |
The following image shows the Counts tab in the Visual Discovery Properties dialog box.
Presents a subset of the statistics.
Presents statistics about the selected item(s).
The pop-up menu appears when you right-click a Visual Discovery control in the analytical dashboard. These options do not appear when you are developing in HTML Composer.
Shows unselected data in gray. If Show Unselected is not checked, unselected data is omitted from the display.
To add unselected data, either turn on Show Unselected in the Properties dialog box, or use the right mouse button menu in the view and click Select All.
Shows indented text fields if the text has leading white space. When this option is not selected, the leading white space is ignored in text fields so that all fields start against the left column border.
Presents a subset of the statistics.
Presents statistics about the selected item(s).
Restores the graph to the initial sort order.
Enables you to search for a specific value.
Exports the data to a file of the type you specify, for example, Microsoft Excel®.
Shows text in a normal, readable size.
Zooms the data sheet so it contains all the rows of data, some of which may be overplotted to fit.
Shows the entire table in the current window. If there are fewer table rows than will fit in the window at full size, then the lines are shown in a larger font with more spacing. If there are more lines than will fit, then they are reduced to a smaller size, with a minimum of 1 pixel high. If all table rows does not fit at 1 pixel high, then lines are overplotted to allow all to fit. When values are overplotted, the line that is the longest or with the hottest color is drawn on the top, obscuring all others under it.
Draws text as one-pixel-high lines. It is helpful when you need to reduce the size of the text to see more of the data. Depending on how many lines you have in your table, this may still require paging to see all rows.
Reverses the previous action. You may repeatedly undo actions retained in the history file for your current session by selecting Undo over and over again. A description of the previous action appears on the pop-up menu. If you have performed no action, Undo is not available for selection and no action appears to the right of the word Undo.
Restores the previous undo action. If you have performed no action, Redo is not available for selection and no action appears to the right of the word Redo.
Selects all of the items in the graph. When you choose Select All, any previous selections are ignored. Selection state returns to the original setting.
When selected, all of the items become unselected. All items appear in the unselected color (gray, by default) or are hidden in the graph (if hide unselected is active).
Reverses the selection state of items. Selected items become unselected and unselected items become selected.
Excludes (temporarily removes) items from the graph.
Restores the items you excluded. If you accidentally excluded the unselected, this menu option restores those excluded items.
Enables you to save the graph to a GIF or JPEG file.
Enables you to copy the selected component and paste it to another file.
Takes you to the collection of tabs available for the respective visualization component. Common tabs include Data, Selecting, and Colors.
WebFOCUS |