Stats Grid
The Stats Grid is used for displaying SPC, DMS, OEE, Task, and Accountability statistics.
Settings
| Setting | Description |
|---|---|
| Label | The title to display on the table. |
| Script ID | Identifies how this table is referenced in Dashboard Scripts. |
| Columns | The columns to display in the Stats Grid. |
Columns
Group Columns
Group columns are used to control how the data is aggregated when calculating statistics. One row will be drawn for each unique combination of values in each Group column. Group columns aggregate data in the same way as the Split By property on most other charts.
When a Stats Grid is initially created, it has a Process Group column by default.
When Characteristic is selected for a Group column, SPC data and non-SPC data will never appear on the same row. All non-SPC data will be assigned the Not Set Characteristic.
When no Group column is set to Characteristic, Short Run will be performed for selected SPC Value columns.
Value Columns
Value columns are used to display the value of statistics. If no data was present for a Value column in a given row, the text "Not Set" will be displayed.
Each value column must have a Retrieval selected. A Stats Grid may have Value columns with different Retrievals, allowing comparison of the same statistic across different Retrievals.
Conditional Formatting
Value columns may have conditional formatting applied, allowing cells to be colored based on the value.
Interaction
Any cell which corresponds to a Value column and is set to a value other than Not Set may be clicked to draw a chart based on the data which was used to calculate the statistic in the cell. The available charts will be based on the data type of the statistic in the cell.
Customization
The Stats Grid may have its properties updated through scripting, but may not be customized through scripting in any other way.
Download
Tables may be saved as a CSV for offline use by clicking the Download button. If multiple tables have been drawn, they may be downloaded individually by changing the view to the desired table.
