April Quinn-Paquet

Member

Calculated columns, flagging rules, and filtering

Get to the results you want to see in less time than you imagined

Data processing software has become more than just a quantitative tool to tell us how much is in a sample. Now with the immense volumes of data being generated in high-throughput environments, there is an increase in demand for these software tools to be able to filter and flag large amounts of data based on particular criteria, and it all needs to be easy to use and interpret!

With the intuitive and easy to use SCIEX OS software for quantitative and qualitative data processing, you can see through the chaos. The processing method’s Calculated Columns and Flagging Rules features allow the easy creation of useful flagging criteria. These features, along with the capability of being able to filter on each column in the Results Table, provide a “review by exception” experience.

Learn more about SCIEX OS software and the calculated columns, flagging rules, and filtering on columns in SCIEX University:

Videos

 

Helpful operators and functions
Please note: formulas follow the order of operation rules

Operator or Function Description
/ Divides the preceding value by the following value.
* Multiplies the preceding value by the following value.
Subtracts the following value from the preceding value.
+ Adds the preceding value to the following value.
( ) Specify the order of operation. Enclose calculations to be performed first in parentheses.
ABS The non-negative value of a real number (x) without regard to its sign. Also referred to as modulus [x].
COUNT The number of items in a collection.
GET The value for a specific component.

GET is not available on the calculator, but can be typed in the format:

GET([Results-Table-column]; ‘Component-Name‘)

GETGROUP The value for a specific transition in a group.

GETGROUP is not available on the calculator, but can be typed in the format:

GETGROUP([Results-Table-column]n), where n is the number of the transition in the group.

Note:   If no groups are defined on the Components page, then the GETGROUP functions treats all components as members of the same group.

INTERCEPT The point where the graph of a function or relation intersects with the opposite axis of the coordinate system.

INTERCEPT is not available on the calculator, but can be typed in one of the following formats:

  • INTERCEPT (X-value;Y-value)
  • INTERCEPT (Y-value)

Note:   If only one value is specified, then it is used as the Y value, and Actual Concentration is used as the X value.

MAD (Median Absolute Deviation) A measure of the variability of a univariate sample of quantitative data.
MAX The largest value in a collection.
MEAN The sum of a list of numbers divided by the number of numbers in the list.
MEDIAN The value that separates the higher half of a data sample, a population, or a probability distribution, from the lower half.
MIN The smallest value in a collection.
SLOPE A number that describes both the direction and the steepness of the line. Also referred to as gradient.

SLOPE is not available on the calculator, but can be typed in one of the following formats:

  • SLOPE (X-value;Y-value)
  • SLOPE (Y-value)

Note:   If only one value is specified, then it is used as the Y value, and Actual Concentration is used as the X value.

STDEV (Standard Deviation) A measure that is used to quantify the amount of variation or dispersion of a set of data values.
SUM The sum of the list of numbers in a collection.

 

RUO-MKT-18-10566-A

 

Join the discussion

Comment below on this article and our team will answer your questions.

0 Comments

Submit a Comment