Using the Data Table Control dashboard control

Display detailed user-selected data and traceability values using the Data Table dashboard control, which can easily be converted into a GainSeeker chart or full-size data table for deeper analysis (see Using right-click menus on dashboard controlsView data... and Chart... options).

This control can automatically refresh at a time interval you define so it displays the latest data or it can refresh along with the dashboard window.

This is an example of how a Data Table control might look on a running dashboard, depending on the properties you assign to it:

 

Contents  [Hide]

 

The Data Table Properties dialog options

Some of the Data Table control properties (attributes) may be familiar in usage and not require additional explanation. The properties that may have been specifically designed for GainSeeker users are featured in this topic.

See Using the Properties dialog

Adding a Data Table control to a dashboard window

  1. Click the Data Table button on the dashboard controls toolbar on a dashboard window that is open in design/edit mode.

The Dashboard Control Retrieval dialog opens. See Using the Dashboard Control Retrieval dialog

  1. Click OK or Next after a retrieval is selected on the Dashboard Control Retrieval dialog.

The Data Table control opens on the host dashboard window in design/edit mode. The selected data retrieval will display after the dashboard window is saved in design/edit mode and reopened in run mode.

For information on moving the Data Table on the dashboard window see Changing the Data Table control location on a dashboard window

Editing the Data Table control properties

There are two methods for selecting the Data Table for edit:

The Properties dialog box menu changes to display the DataTable setting and the properties grid displays the properties specific to this control.

Editing the (Data columns) property

To change the column labels in the Data Table:

  1. Click the (Data columns) property value cell in the Behavior category.
  2. Click the ellipsis buttonin the value cell.

The Data table columns dialog opens.

Editing the Data (Retrieval) property

To change the (Retrieval) property setting in the Properties dialog:

  1. Click the (Retrieval) property value cell in the Data category.
  2. Click the ellipsis buttonin the value cell.

The Dashboard Control Retrieval dialog opens. See Using the Dashboard Control Retrieval dialog

Other Data Table control properties

Using the Data Table columns dialog

Select an existing column label group for the Data Table columns to display, create a new one, or copy and edit a group using the Data table columns dialog.

To select an existing column labels group:

  1. Click a group name in the Select columns to display list to select it.

  2. Click OK.

To create a new column labels group, edit an existing group, or copy a group:

  1. Click the New... , Edit... or Copy... button.

The Enter Value dialog opens.

  1. Click the New report name text field on the Enter Value dialog.

  2. Enter a name for the new column group. Then, click OK.

  3. The Data table columns - [group name] dialog opens with the name of the new group in the dialog caption. See Using the Data table columns - [group name] dialog.

Using the Data table columns - [group name] dialog

Choose the individual column data and traceability labels to include in a column group using this dialog. See Specifying column types

Any column labels that may have been included in an existing report display in the Selected list. Any labels that can be added to the report display in the All list. See Using the Data table columns buttons and features for tips.

  1. Click OK on the Select Report [report name] dialog after selections for the report are finished.

The Select Report dialog opens with the new statistics report name highlighted in the Select a statistics list.

  1. Click OK.

Using the Data Table columns - [group name] buttons and features

To Select multiple labels:

— Hold the CTRL ("control") key while clicking individual labels within a list. The selected labels will highlight.

Changing the location of the control on a dashboard window

There are two ways to change the location of the control on the dashboard: