Previous  Next          Contents  Index  Navigation  Glossary  Library

Functional Grouping and Processing

Functions are used to group quality results when creating Pareto charts, trend charts, and custom Quality Results ReportWriter reports.

Functions and Groups

You can use functions to specify how to group and process quality results values associated with a collection plan element. The five available functions are as follows:

Sum Sums all quality result records.
Count Counts the number of quality result records.
Average Calculates an average of the quality result records.
Min Evaluates and groups quality results to find those records with the minimum value.
Max Evaluates and groups quality results to find those records with the maximum value

Note: If you select a function when using the Quality Results ReportWriter, all the reported columns where a function has not been selected are grouped together. For example, assume you want to report Item, Department, and Test Voltage (Average). The report displays the average test voltage for each item and department.

Functions and Data Types

The data type -- numeric, character, or date -- of the chosen collection plan element determines what function or functions can be applied to quality results values for a collection element. You can, for example, select and sum quality results for a "numeric" Quantity Defective collection plan element. Similarly for a "non-numeric" (character or date) Defect Code collection plan element, you can choose the "count" function to produce a count of all the Defect Codes results that meet the specified selection criteria. Numeric quality results can also be totalled.

Data types and the functions that can be performed for values of each are as follows:

Numeric data type Numeric values can be Summed, Counted, and Averaged. They can also be grouped based on Minimum or Maximum quality result values.
Character data type Character values can only be Counted.
Date data type Date values can only be Counted.
Data types are assigned as you define your collection elements. See: Defining Collection Elements.

         Previous  Next          Contents  Index  Navigation  Glossary  Library