Reference: |
A data sheet creates a table-style view of a set of fields so you can easily uncover interactions and patterns. Data sheets are particularly useful for viewing dynamic top or bottom lists or dividing data into groups for comparison to identify both common and unique attributes.
An example of a data sheet is shown in the following image.
Data sheets created using WebFOCUS Visual Discovery enable you to:
The following image shows the Data Sheet tab in the Visual Discovery Properties dialog box.
Shows text in a normal, readable size.
Draws text as one-pixel-high lines. This 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.
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 (the more common case), 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 longest or with the hottest color is drawn on the top, obscuring all others under it.
Shows unselected data in gray. If the Show Unselected check box is not selected, unselected data is omitted from the display.
To add unselected data, either select the Show Unselected check box in the Properties dialog box, or use the right mouse button menu in the view and click Select All.
Indents 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.
Shows the reduced line representation option. When this option is not selected, the display is locked into text mode.
Displays the entire string of a truncated line when the cursor is placed in the column.
Displays the name of each selected (in focus) field.
Sorts the glyphs by the specified field.
Reverses the sort order.
Removes the highlighted field from the sort.
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 choose Select All.
Indents 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.
Restores the graph to the initial sort order.
Enables you to search for a specific value.
Saves the data to a file.
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, then 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. This 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 |