Charting external data lets you analyze data that is not stored in GainSeeker or analyze stored GainSeeker data in novel ways. It is available from the File menu in the GainSeeker Charts module.
There are two steps to charting external data:
Choose how to access the external data:
Copy and Paste the data set you want to analyze.
Run a Python script that creates the data set you want to analyze.
Perform analysis on the external data.
You may want to use this feature if:
Your quality, performance, scheduling, or other business data is stored in files, databases, or other sources on your system and you do not want to maintain a second copy of this data in the GainSeeker tables. You can still store the data you are analyzing in the GainSeeker tables if you later choose.
You want to analyze GainSeeker data in ways that are different
from how it was stored. This is typically accomplished with a Python
script that retrieves data from GainSeeker and uses it to create a
new data set for analysis.
For example, for Scripted SPC
data, you can download the Library
script named CombineStandards
which provides a boilerplate for combining multiple, related standards
into one data set for analysis (for example, one line on a control
chart).
All of the standard features for analyzing data and printing reports are available when charting external data from the File menu, except for:
retrieval options that specify a date period, maximum number of data points, and a filter or Quick filter. The data set you provide by Copying and Pasting or by running a Python script should specify only the data you want to analyze.
editing the external data you are analyzing from a chart or data table. The data set you provide by Copying and Pasting or by running a Python script should provide correct data for analysis.
DMS cost analysis where cost information comes from the standard's cost per unit. This includes the statistics Total sample cost and Total NCU cost.
drilling into OEE defect data.
right-clicking on an SPC Control chart with grouped data and choosing New Chart for Group or New Charts for Groups.
saving a chart of external data in a Desktop. (For scripted data, you can create a Dynamic Desktop for your external data instead.)
re-retrieving data by clicking Refresh Family from the GainSeeker Charts Window menu or by clicking Timer on the GainSeeker Charts Options menu. Clicking Refresh Family does not re-retrieve the data.
If these features are needed, you can save the external data in GainSeeker and then delete the range of data from GainSeeker when finished.