How is the GETSTAT Function Used in SCIEX OS Software?

For research use only. Not for use in diagnostic procedures.

Answer

Processing methods in SCIEX OS software contain a Calculated Columns option, where users can process data using a custom formula and output the results into a new column in the results table. This article discusses how to create a custom calculation that pulls statistics pane calculations into a custom column using the GETSTAT function. Depending on what is specified in the calculation, the GETSTAT function adds custom columns to the results table for the mean, standard deviation, percent CV, or average accuracy, and these values can then be output to a report using the built-in reporter system in SCIEX OS software. 

To add the custom calculation, open the processing method and select the Calculated Columns tab. To add a new formula, select Add, and then select Formula. A new screen appears: Use the calculator to create a new formula. To create a custom column, enter the name of the calculation, and then type in the formula following this general syntax: 

GETSTAT('Statistics-pane-column';'Metric')

where the 'statistics-pane-column' can only include one statistics function: mean, standard deviation, percent CV, and average accuracy across replicates; 'Metric' refers to the data in the statistics pane columns: Area, Calculated Concentration, and Height, and Calibration Y-Value, which is not a statistics pane column, but the value of the the y-axis in the calibration curve. 

Below are some examples of correctly written GETSTAT functions:
GETSTAT('Mean';'Calculated Concentration')
GETSTAT('Percent CV';'Calculated Concentration')
GETSTAT('Percent CV';'Area')

The GETSTAT syntax can be expanded so that samples used for the calculation can be grouped together in a specified way. By default, when grouping is not specified, then GETSTAT extracts the statistical values for only standard and QC samples that are grouped by actual concentration. In SCIEX OS software 3.4, the functionality of GETSTAT is expanded to include grouping, and the syntax can be expanded:

GETSTAT('Statistics-pane-column';'Metric';'Grouping')

To learn more about how to use the grouping options for GETSTAT, users can consult the article Formula Page in the Help System in SCIEX OS software 3.4 (accessible by selecting the question mark in the upper right corner of the screen). The knowledget article, Using the GETSTAT calculated column for unkown sample types In SCIEX OS Software 3.4, also contains more information on this topic: https://sciex.com/support/knowledge-base-articles/getstat-calculated-column-in-sciex-os-3-4_en_us