Data Table dashboard control

The Data Table dashboard control displays a GainSeeker data table on the dashboard window.

 

Contents  [Hide]

 

Adding a Data Table control to a dashboard window

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

  2. On the Dashboard Control Retrieval window, select a retrieval and then click Next.

    This adds the Data Table control to the dashboard window.

  3. Move this control to the desired location.

  4. Edit the properties for this control.

Moving the control

There are two ways to change the location of this control on a dashboard window that is open in design/edit mode,

Editing the properties of the control

There are two ways to select this control so that you can edit its properties (when the dashboard is open in design/edit mode):

Significant properties for this control include:

Property

Default setting or default display

Allows

Appearance

BorderStyle

None: No border is displayed around the outside edge of this control.

Choose the style of border to display.

Chart Skin

None: Default display settings are applied to this data table.

Select a chart skin to apply its Chart override settings such as colors, fonts, etc.

Z-Order

0: Lowest priority when overlapped by other controls.

When objects overlap or when the dashboard is saved as an .rtf file (such as when sending to Word or WordPad), a control with a higher Z-Order will be displayed and exported above a control with a lower Z-Order.

Enter a number to specify the order you want for this control in relation to other controls on the same dashboard.

Behavior

(Data columns)

Determines which table columns are displayed and in what order.

In most cases, the default data table columns are set by the SPC default reports or DMS default reports for the configuration.

The exception is when this control's DataTableType property is MultipleWithMatchedColumns, in which case the data table columns are determined by this control's Chart Skin property (Columns used to match rows from different retrievals setting) and this property is set to N/A.

You can select a different SPC format or DMS format (except when this property is N/A).

For an SPC retrieval, the list of report formats when the DataTableType property set to Single is different from when that property is set to Multiple.

DataTableType

  • If you selected an SPC retrieval when adding this control to the dashboard, this defaults to Single, which displays the first combination of SPC standard, date period, and filter in the retrieval.

    This is equivalent to creating a standalone Data Table window from the "One window for each" list.

  • If you selected a DMS retrieval when adding this control to the dashboard, this defaults to Multiple, which displays all of the DMS data in the retrieval.

    This is equivalent to creating a standalone Data Table window from the "One window for all (one retrieval)" list.

For an SPC retrieval, you can change this to one of the following:

  • Multiple: displays all SPC standards, date periods, and filters in the retrieval.

    This is equivalent to creating a standalone Data Table window from the "One retrieval for all (multiple retrievals)" list.

  • MultipleWithMatchedColumns: matches date/time stamps and traceability to display raw data values for multiple standards.

    This is equivalent to creating a standalone Multiple Data Table window from the "One retrieval for all (multiple retrievals)" list.

Timer

0: Do not set a timer to automatically refresh this control with the latest data.

Refreshing the entire dashboard window can still refresh this control.

Set the number of seconds to elapse before automatically refreshing this control.

TimerFileNameExport

[blank]

If you have GainSeeker Server Edition, you can save an image of this control to a file each time this control is refreshed by this control's Timer property or by the Dashboard window's Timer property.

To use this feature, click this property and then click the ellipsis button . Use the Save As window to select a location and enter a file name.

  • After each Timer refresh, an image of this control will be saved to the file name and location you specified. If the file already exists, it will be overwritten. (Manually refreshing the dashboard does not save the image to file.)

  • If the GainSeeker Charts module is minimized, dashboard images cannot be correctly exported to files.

To turn off this feature, select the file name in the value field and delete it.

Data

(Retrieval)

The retrieval you selected when adding this control to the dashboard.

Select a different retrieval for this control.

  • If you initially selected an SPC retrieval, you can choose another SPC retrieval.

  • If you initially selected a DMS retrieval, you can choose another DMS retrieval.

DesignData

True: While you are designing/editing the dashboard, display fictional "data" instead of waiting for this control to retrieve actual data from your GainSeeker database and calculate statistics.

When running the dashboard, users will see the actual data and statistics from the retrieval, not this fictional "data".

False: While you are designing/editing the dashboard, retrieve the actual data from your GainSeeker database and calculate statistics. This takes more time than using the fictional "data", but you can see exactly how the control will look when running the dashboard, and you may find it easier to fine-tune the properties of this control.

This option is only used temporarily until you stop using design/edit mode; each time you open the dashboard in design/edit mode, this property is automatically reset to True.

SPC Data

  • If you selected an SPC retrieval when adding this control to the dashboard, this is True.

  • If you selected a DMS retrieval when adding this control to the dashboard, this is False.

You cannot change this property.

Layout

Anchor

Top, Left: When the dashboard window is resized:

  • The distance from this control's top edge to the top edge of the dashboard window will not change.

  • The distance from this control's left edge to the left edge of the dashboard window will not change.

  • The size of this control will not change.

You can select or clear any combination of the Top, Bottom, Left, and Right edges.

When the dashboard window is resized:

  • For any edge that is selected (Top, Bottom, Left, or Right), the distance between that edge of the control and that edge of the dashboard window will not change.

  • If two opposing edges are selected (both Top and Bottom, or both Left and Right), the control will automatically resize along that dimension, which maintains that fixed distance to both edges of the dashboard window.

  • If two opposing edges are cleared (both Top and Bottom, or both Left and Right), this control will maintain a relative top/bottom or left/right position within the dashboard window. Those dimensions of the control will not resize as the dashboard window is resized.

Dock

None

You can align this control to one edge of the dashboard window and autosize the control to match the size of that window edge. or set it to fill the remaining space in the dashboard window. If multiple controls on this dashboard are docked, they will be aligned to each other and resize as a group. The order in which controls are added to the dashboard affect the priority in which they are docked.

Choose from Top, Left, Right, Bottom, Fill (fills the dashboard window), or the default None (not docked).

Location

[varies]

You can manually set the desired X (horizontal) and Y (vertical) pixel coordinates of the upper-left corner of the control relative to the upper-left corner of the dashboard window.

Size

[varies]

You can manually set the Width and Height in pixels for this control.