Defining the Grid Rows and Columns

Set options for defining and sorting rows and assign properties to columns for SPC and DMS data retrievals—on the same Dashboard Grid control—using the Define Grid Rows and Columns window.

 

Contents  [Hide]

 

Using the Rows tab

Use the Rows tab on the Define Grid Rows and Columns window to select options for defining and sorting rows on the Dashboard Grid.

The Sample grid on the Rows tab displays a representation of how various selections will display in the grid.

Rows defined by

The Rows defined by setting determines how information will be divided into rows.

By default, each row on the Dashboard Grid displays information for one SPC standard or DMS standard.

However, you can change this to divide the rows by the values in one traceability field. For example, you might wish to display information for each Line - regardless of what parts are currently running on those lines.

When a Dashboard Grid includes a column for SPC data, this setting impacts how numbers are formatted and the speed of data retrieval:

Hide Column in Grid

GainSeeker automatically adds the Rows defined by column to the grid.

However, you can hide this column if desired. For example, you may hide the column because the information that column will display is repetitive, such as when you filter for a single standard for the whole grid.

Hiding the column does not affect how data is retrieved or how statistics are calculated.

To hide the Rows defined by column on the grid, select the Hide Column in Grid check box.

Rows grouped by

Optionally, you can use the Rows grouped by property to further subdivide the rows on the Dashboard Grid.

If used, each row on the Dashboard Grid displays information for each unique combination of the Rows defined by and Rows grouped by values.

Rows sorted by

Sort rows in Ascending or Descending order to prioritize data for a single statistic or traceability label using the Rows sorted by drop-down list. (All other statistics and traceability fields will also sort accordingly.) The rows are sorted by Part Number by default if another priority is not set.

For more information, see How real-time failure rows are sorted.

To set the data priority:

  1. Click the Rows sorted by list and select an option.

  2. Select Ascending or Descending to sort the data values in ascending or descending order.

 

Sample grid

The Sample grid on the Rows tab displays a representation of how various selections will display in the grid.

Using the Columns tab

Use the Columns tab on the Define Grid Rows and Columns dialog to set retrieval options for the Grid columns.

To add a column:

  1. Click the Columns tab on the Define Grid Rows and Columns window.

  2. Click the SPC data or DMS data options button in the Add column field to assign that data type to a new column. Then, click Add.

A highlighted bar representing the new column opens in the Defined columns list field with the word (caption):

The Column Properties grid on the Columns tab displays SPC or DMS data properties that can be edited for that column, depending on which retrieval was selected for it. See using property value cells for information on using value cells.

Repeat steps 1–2 above to add additional columns to the Defined columns list. The values for each column can be edited using the Column Properties grid on the Define Grid Rows and Columns dialog. See Editing the Column properties

To delete a column:

  1. Click a column listing in the Defined columns list to select it.

  2. Click the Remove button on the Define Grid Rows and Columns dialog.

Using the Columns tab Move up/down and Set for All buttons

The Move up and Move down buttons

Determine the order of the columns in the finished Grid using the Move up and Move down buttons on the Define Grid Rows and Columns dialog.

To change the position of a column in relation to other columns in the finished Grid (The top position in the Defined columns list represents the first column in the finished grid.):

  1. Click a column listing in the Defined columns list to select it.

  2. Click the Move up or Move down button until the column is correctly positioned in the list.

The Set for All button

Apply the same property value setting for one column to all or some of the other columns in the Dashboard Grid—depending on the data type—using the Set for All button on the Columns tab of the Define Grid Row and Columns dialog.

To use the Set for All button:

  1. Click a column in the Defined columns list to select it for edit.

  2. Click a property value cell in the Column Properties grid.

  3. Edit the property value for that column (See Editing the Column Properties for more information.). Keep the property value cell selected (or click it to reselect it).

  4. Click the Set for All button located below the Column Properties grid to apply that value to other columns in the finished Dashboard Grid.

Use the following table to determine which columns a property value will be copied to, based on the type of data in the source column:

 

This property from Source column can be copied to:

Source column

(Caption)

Cell display

Cell display format

Colors defined by

Date period

Detail defects

Maximum data count

Filter

SPC data

SPC DATA

Both SPC and DMS columns

Only SPC columns

Both SPC and DMS columns

Only SPC columns

Both SPC and DMS columns

exists only for DMS

Only SPC columns

Only SPC columns

---

DMS DATA

Both SPC and DMS columns

Only DMS columns

Both SPC and DMS columns

Only DMS columns

Both SPC and DMS columns

Only DMS columns

exists only for SPC

Only DMS columns

---

Editing the Column Properties

Use the Column Properties grid to set the statistic, defect process, caption, filter, date period, and other settings for a Grid column.

To select a column for edit:

  1. Click a column in the Defined columns list to select it for edit using the Column Properties grid.

The selected column is highlighted in the list and any property values previously assigned to that column display in the Column Properties grid.

Cell display property

You can choose a statistic for which the selected column cells will retrieve data using the Cell display property.

Note: Selecting one of these statistics: Sparkline, Chart, Chart (2x height), or Chart (4x height) from the list of available statistics displays a chart in each of the individual cells in the column. See Displaying charts in grid cells for more information.

To select a statistic:

  1. Click the property value cell for Cell display on the Column Properties grid. Then, click the ellipsis button in the value cell.

The Select Statistic dialog box opens, listing statistics for either SPC data or DMS data, depending on which data type was assigned to that column when it was added.

  1. Click a statistic in the Select Statistic dialog to select it for that column. Then, click OK.

(Click the Show full list button to view all possible statistic labels. Click the Show short list button to revert back to the shorter list of options. Enter any part of a statistic name in the Search text field to limit the list to closer matches.)

  1. The Cell display property value cell displays the selected statistic for that column.

A caption can now be added to the column. See editing the (Caption) property.

 

Note about [Detail] Statistics

Most statistics display information for all defects found on each row of the statistical filter. This is true for all statistics except those statistics preceded by [Detail], which display information for only the selected defect. If you display a [Detail] statistic, the best practice is to add the name of the selected defect to the column caption.

(Caption) property

Assign a caption to a column using the (Caption) property in the Column Properties grid on the Define Grid Rows and Columns dialog.

To assign a caption to a column:

  1. Click a column in the Defined columns list on the Columns tab to select it.

  2. Click the (Caption) property value cell. Then, enter a caption for that column in the text field. Usually, a caption will be the same or a similar name to the statistic that was selected for the column using the Cell display property, as in this example:

  1. Click outside the (Caption) property value cell to add the caption to that column in the finished Grid. Note that the selected column in the Defined columns also displays the (Caption) label as in this example, which helps to distinguish columns while they are being edited:

To change the position of a column relative to other columns in the Grid, see Using the Move up and Move down buttons.

Cell display format property

You can use this property to apply particular formatting to numeric values or date/time values displayed in a particular column on the Data Grid. For example, you could use this property to format one column's statistical value to two decimal places.

This property does not affect other windows that are generated from the Data Grid, such as Data Tables. For more information, see Rows defined by.

To set a Cell display format:

  1. In the Defined columns list, click a column to select it.

  2. In the Column Properties grid, click the Cell display format property. Then enter an appropriate Numeric format or Date/Time format.

Colors defined by property

Set the colors a column will display when the value cells in a column fail or pass a user-set filter with the Colors defined by property. Or set up color regions for a column. By default, the column cells have no color.

To set colors:

The Column Display Colors dialog opens. See Using the Column Display Colors dialog

Date period property

Set the date range so a column only retrieves data points that fall within the user-specified date range. Narrowing the date range can significantly shorten retrieval time. By default, the property is set to retrieve data for all date ranges.

To edit the Date range:

  1. Click a column in the Defined columns list on the Columns tab to select it.
  2. Click the Date period property value cell in the Column Properties grid. Then, click the ellipsis button in the value cell.

The Date Period dialog opens. See Selecting the Date Range for Retrieval for general information on selecting a data range.

  1. Click OK on the Date Period dialog after making a selection.

Filter property

To assign a filter to a column retrieval:

  1. Click a column in the Defined columns list on the Columns tab to select it.
  2. Click the Filter property value cell. Then, click the ellipsis button in the value cell.

The Select Filters dialog box opens. See Using the Select Filters dialog.

Maximum data count property (SPC retrieval-assigned columns)

Restrict a column retrieval to only displaying a limited number of the most recent available SPC data records on the Dashboard Grid using this property. (A value of 0 displays all available records for that column on a Grid.)

To edit the property:

  1. Click a column in the Defined columns list on the Columns tab to select it.

  2. Click the Maximum data count property value cell text field. Select any numeric value in the text field. Then, enter a new numeric value.

  3. Click outside the property value cell to enter the value.

SPC data property (True or False)

The column in the following example is set to display DMS data as indicated by the SPC data property value cell displaying the word False. If the selected (highlighted) column in the Defined columns list had been set to display SPC data, it would display the word True. The data type for a column is selected when a new column is added and cannot be changed to the other type once it is added.

Detail defects property (DMS retrieval-assigned columns)

Use the Detail defects property to specify defects that limit the analysis to the critical few for a comparison.

To edit this property:

  1. Click a column in the Defined columns list on the Columns tab to select it.
  2. Click the Select Defects property value cell. Then, click the ellipsis button in the value cell.

The Select Defects dialog opens. See Using the Select Defects dialog.

Most statistics display information for all of the defects found on each grid row. This is true for all statistics except those preceded by [Detail]. These statistics only display meaningful information when a single defect is selected for the Detail defects property. If you display a [Detail] statistic, the best practice is to add the name of the selected defect to the column caption.

Colors Defined By property

You can define colors to display on cells in the column, based on the value of each cell.

There are three ways to set colors:

To select a Statistical filter:

  1. Click the Statistical filter settings radio button. Then, click the ellipsis button in the Statistical filter name text field.

The Select Filters dialog opens. See Using the Select Filters dialog box below.

Using the Select Filter dialog

Create a new filter for a column or select, copy, or edit an existing filter using the Select Filters dialog. For more information, see Statistics filters and How statistics rows are filtered

To select an existing filter:

  1. Click a filter name in the Select a filter from the list field to select it for a column.

  2. Click OK on the Select Filters dialog.

To create a new filter:

  1. Click the New... button on the Select Filters dialog.

The Enter Value dialog opens.

  1. Click the New filter name text field.

  2. Enter a name for the new filter. Click OK.

The Filter Builder dialog opens. See Setting the contents of a filter

To edit an existing filter:

  1. Click the Edit... button on the Select Filter dialog.

The Filter Builder dialog opens. See Setting the contents of a filter

To copy an existing filter:

  1. Click the Copy... button on the Select Filter dialog.

The Enter Value dialog opens.

  1. Click the New filter name text field.

  2. Enter a name for the new filter. Click OK.

The Filter Builder dialog opens. See Setting the contents of a filter

To combine filters:

  1. Press and hold the CTRL key while you click the filters you want to combine.

  2. Then, select the Combine checkbox.

Using the Filter Builder dialog

Use the Filter Builder dialog to set filters and conditions for the retrieval in a column.

See Setting the contents of a filter for usage guidelines.

Using the Select Defects dialog

Use the Select Defects dialog to select specific defects to include in a column for comparison analysis. [Select all Defects] is the default setting. For more information, see Selecting Defects

Selecting Defects involves selecting (1) a defect process group, and (2) whether to include all the defects associated with that group or select individual defects in the retrieval.

To select a defect group :

  1. Click a defect group in the drop-down list or leave it set to [Include all Defects] (you can remove unwanted defects from the latter setting) to select it for a column.

Individual defects that are included in the selected group display in the Selected Defects list. Other available individual defects display in the Available Defects list.

  1. Use the Add >> and << Remove buttons to select or deselect individual defects for the analysis.

The Select which [defects] you want to include in your analysis drop-down list displays the [Select specific Defects] after any changes are made.

  1. Click OK on the Select Defects dialog.