Data Sheets

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 example

Data sheets created using WebFOCUS Visual Discovery enable you to:


Top of page

x
Reference: Data Sheet Tab

The following image shows the Data Sheet tab in the Visual Discovery Properties dialog box.

Data Sheet tab

Line Representation
Full Size

Shows text in a normal, readable size.

Pixel/line

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.

Fit All

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.

Show Unselected

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.

Indent Text

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.

Scale Mode

Shows the reduced line representation option. When this option is not selected, the display is locked into text mode.

Tool Tips

Displays the entire string of a truncated line when the cursor is placed in the column.

Display Focus Line

Displays the name of each selected (in focus) field.

Sort By

Sorts the glyphs by the specified field.

Reverse Sort By

Reverses the sort order.

Remove

Removes the highlighted field from the sort.



x
Reference: Data Sheet Pop-up Menu

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.

Show Unselected

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.

Indent Text

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.

Original Order

Restores the graph to the initial sort order.

Find in column

Enables you to search for a specific value.

Export

Saves the data to a file.

Full Size

Shows text in a normal, readable size.

Fit Selected

Zooms the data sheet so it contains all the rows of data, some of which may be overplotted to fit.

Fit All

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.

One Line/Pixel

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.

Undo

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.

Redo

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.

Select All

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.

Unselect All

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).

Toggle All

Reverses the selection state of items. Selected items become unselected and unselected items become selected.

Exclude Unselected

Excludes (temporarily removes) items from the graph.

Restore Excluded

Restores the items you excluded. If you accidentally excluded the unselected, this menu option restores those excluded items.

Save Image

Enables you to save the graph to a GIF or JPEG file.

Copy Image

Enables you to copy the selected component and paste it to another file.

Properties

Takes you to the collection of tabs available for the respective visualization component. Common tabs include Data, Selecting, and Colors.


WebFOCUS