It is possible for GainSeeker to calculate some of the SPC or DMS statistics and provide them to an Advanced report or to an Advanced retrieval in a Mixed report.
For example, to let GainSeeker calculate the Mean for SPC data with a subgroup size of 3 or less, your SQL query must return columns named DATA1, DATA2, DATA3 and SUBSIZE. If the table you are querying does not contain columns with these names, you can use the syntax SELECT <column_name1> as DATA1, <column_name2> as DATA2, ... so that the columns in the query result set still have the names that GainSeeker needs for calculating statistics.
For example, GainSeeker cannot calculate the Cpk for an Advanced report or retrieval, because specification limits are needed to calculate this statistic and specification limits are stored in the SPC standard.
On the Statistics tab of the Advanced Report Retrieval Settings screen, you can choose which statistics (if any) to make available for the Advanced report or retrieval. If you choose any statistics that GainSeeker cannot calculate for the reasons listed above, GainSeeker will simply fail to calculate that statistic or provide it to the report. You can specify either SPC statistics or DMS statistics for the report or retrieval.
To choose SPC statistics for the report or retrieval, click SPC. For more information on choosing statistics for dynamic reports, see Choosing the statistics.
To choose DMS statistics for the report or retrieval, click DMS. For more information on choosing statistics for dynamic reports – including the Pareto detail and DPU detail settings – see Choosing the statistics. For information on setting the Statistics grouped by option, see Choosing the DMS standards or processes.