Using GETSTAT with unknown sample types in SCIEX OS software 3.4

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

Answer

GETSTAT received additional functionality in SCIEX OS software 3.4. Found in the Calculated Columns section of the processing method, the GETSTAT function can now pull in statistics for unknown samples; previously, GETSTAT only worked with QC and standard samples. The new GETSTAT functionality now permits averaging of the calculated concentrations for replicate unknown samples, among other functions.

The syntax for GETSTAT in previous versions of SCIEX OS software consisted of two sections: 1) 'Statistics-pane-column' and 2) 'Metric':

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

where 'Statistics pane column' captures values for the mean, standard deviation, percent CV, or average accuracy across replicates; and 'Metric' refers to the values for which statistics are calculated – Calculated Concentration, Area, Height, or Calibration Y-value (y-axis value from the calibration curve).

In previous versions of SCIEX OS software, the grouping of target samples was always done by actual concentration, meaning the standards or QC samples with the same actual concentration would be grouped together for the calculation.

Due to GETSTATs new ability to do these calculations on unknown sample types, a third grouping section has been added to the syntax for GETSTAT:

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

Grouping allows samples to be grouped for statistics calculatons by the following column names: Actual Concentration, Sample Name, Sample ID, Sample Name prefix, Sample Comment, Barcode, Scanned Barcode, and Injection Position. If a grouping option is not specified, then actual concentration is used by default.

The following calculation would give the average calculated concentration of samples with identical sample names and can be applied to when needing to calculate the average calculated concentration of unknowns with duplicate injections.

GETSTAT('Mean';'Calculated Concentration';'Sample Name')

Form more information on the GETSTAT function, see the article in this link: 
https://sciex.com/support/knowledge-base-articles/how-to-use-getstat-function-in-sciex-os-software_en_us