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:

Non-targeted Screening Data Processing Using SCIEX OS software (premium content)
Quantitative Data Processing Using SCIEX OS software (premium content)
- Algorithms and Flagging
- Quantitation and Targeted Identification Data Processing Using SCIEX OS software (premium content)

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.

Calculated columns, flagging rules, and filtering

Join the discussion

0 Comments

Submit a Comment Cancel reply

SCIEX Now™ support network

The destination for all your support needs.

Pin It on Pinterest

Share This