A dashboard for real-time failures will contain one or more columns - each representing a different date range or number of most recent data points. To design the dashboard, use the Columns tab to define at least one column.
To define one or more columns:
Browse the Available date periods or count list to determine the range of data that should be represented by this column.
If you choose Last n records, you will be able to set the number of data records represented by this column.
If you choose Custom by date, you will be able to specify an exact date and time for both the low date/time and high date/time.
For information on applying additional limits to the data retrieved for this column, see Limiting counts and dates for SPC data.
Click the desired period or count in the Available date periods or count list, and then click Add. Alternately, you may double-click the desired period or count.
If you chose Custom by date, you will be prompted to specify a low and high date and time. For more information, see Set Date Range screen.
The item you chose is added to the Selected date periods or count list.
While this item is highlighted in the Selected date periods or count list, you can set the options for this column:
Column Header
This text will be displayed at the top of the column.
If you chose Last n records, the number of records is set to 10. You can use this box to change the number of data records retrieved.
Edit
If you chose Custom by date and need to modify the date range, click this button.
Cell Text
You may choose one or two text items to be displayed in all cells in this column. If you select two text items, they will be displayed in the cell as item A / item B.
Alternately, you my display a single chart item in all cells in this column. The chart items can only be selected from the left-hand list of items.
Options available on the drop-down list include:
text item: |
explanation: |
|
Data count |
The total number of data records retrieved for each row of the dashboard. |
|
|
The total number of real-time failure records retrieved for each row of the dashboard. |
|
Total values |
The total number of data measurements retrieved for each row of the dashboard |
|
Sparkline |
Charts of the data retrieved for each row of the dashboard. Chart scaling: ● The Sparkline is always scaled to the minimum and maximum data points, and no limits (e.g., Control or Gate) are displayed. ● The Chart, Chart (2x height) and Chart (4x height) are scaled according to data points and/or limits as follows: Choosing the limits: Scaling the top of the chart: Scaling the bottom of the chart: Chart height: ● The Sparkline and Chart are sized to the same height as the font used for the dashboard. ● The Chart (2x height) is sized to two times the height of the font used for the dashboard. ● The Chart (4x height) is sized to four times the height of the font used for the dashboard. Chart width: The chart width is automatically sized to six times the height of the chart. This can only be changed by viewing the dashboard, dragging the column header to change its width, changing the design of the dashboard and locking the column width. The data mean is displayed on all charts. You cannot change the colors or line types used to display the data or limits.
|
|
Cp |
Statistics calculated from the data records retrieved for each row of the dashboard. Some of these statistics, such as Cpk, can only be calculated if at least one specification limit is defined in the SPC standard or Short Run process specification that defines this row of the dashboard. If no specification limit is found for a row, these text items will display "NA". If you have configured different labels for these statistics, your labels will be displayed instead of those shown here. If the item you want to display is not available on the drop-down list, click the button to select from the full list of statistics. |
|
Nominal Spec |
Limits set in the SPC standard or Short Run process specification that defines this row of the dashboard. If no SPC standard or Short Run process specification exists for a row, these text items will display "None". If you have configured different labels for these limits, your labels will be displayed instead of those shown here. If the item you want to display is not available on the drop-down list, click the button to select from the full list of statistics. |
|
Last traceability label 1 |
The traceability value from the most recent data record retrieved for this row of the dashboard. These text items will reflect the traceability labels that are configured for your system. |
|
Last Time |
The time or date from the most recent data record retrieved for this row of the dashboard. |
|
Last Part Number |
The name of the SPC standard from the most recent data record retrieved for this row of the dashboard. If you have configured a different label for standards, your label will be displayed instead of "Part Number". |
|
Last X-bar |
The subgroup average from the most recent data record retrieved for this row of the dashboard. |
If the item you want to display is not available on the drop-down list, click the button to select from the full list of statistics.
Note: Some items will use a slower type of data retrieval than others. The number of stars displayed for Speed – where ***** is the fastest type and * is the slowest type – will indicate the relative speed of your choices.
Get data from
Monitor tables
Depending on the way you have configured SPC standards for writing to monitor files, real-time failures and/or good data may be logged to the Monitor tables during SPC data entry.
The Monitor tables contain significantly fewer records than the Full data tables. This means that a column that gets data from Monitor tables will be displayed more quickly than a column that gets data from the Full data tables.
Note: The option to get data from Monitor tables is not available for columns based on the Last n records or for some Cell Text options.
Full data tables
All data records - both good data and data with real-time failures - are stored in the Full data tables, regardless of how SPC standards have been configured to write to monitor files.
This means that the Full data tables contain a complete data set for any standard and date range you select. However, it also means that it takes longer to retrieve and display columns based on the Full data tables than columns based on the smaller Monitor tables.
To define additional columns, repeat the steps above.
When the dashboard contains multiple columns, you may need to consider additional issues:
To change the order of these columns on the dashboard, click one item in the Selected date periods or count list and then click the or button to change its position in the list.
To reduce the number of empty cells - where the row contains no data for the specified date period - click one item in the Selected date periods or count list and then select the Restrict rows to items with data in this date period.
This means that only the rows that can display data for the selected column will be displayed on the dashboard - even if additional data exists for the other columns.
Neither column is restricted. |
Restricted to rows with data in Last month. |
The Restrict check box can only be selected for one item in the Selected date periods or count list.
When you select Monitor tables or Full data tables, the relative speed of retrieving data for this column is displayed:
If you define multiple columns for this dashboard where at least one column gets data from the Monitor tables and at least one other column gets data from the Full data tables, the Mixed label is displayed to inform you that this dashboard uses both types of retrieval: