Quality Statistics By Variables Web Part

The Quality Statistics By Variables Web Part provides a variety of overall statistics for a single variable over the specified period of time.

This Web Part provides a comparison of the actual (test) variable values against the target values.

The reporting time period is displayed at the bottom of the Web Part. To adjust the reporting period, click the Clock icon.

To use this Web Part, you must:

For Cpk, Ppk, Pp, and Cp, the color values indicate the following:

For High, Med, and Low (alarms), the color values indicate the following:

Red is used for the High alarm box to indicate that there is one or more high alarms.
Blue is used for the Med alarm box to indicate that there is one or more medium alarms.
Light blue is used for the Low alarm box to indicate that there is one or more low alarms.
Green is used on all three alarms types to indicate that there are no alarms.

For %Test, %Conf, %Dev, and %Sigma, the color values indicate the following:

This Web Part provides the following information:

High: This is the percentage of variables that had an alarm with a high priority. Click the number to view the Alarm List By Variables Web Part.
Med: This is the percentage of variables that had an alarm with a medium priority. Click the number to view the Alarm List By Variables Web Part.
Low: This is the percentage of variables that had an alarm with a low priority. Click the number to view the Alarm List By Variables Web Part.
#Samples: The number of samples used in the calculations.
%Conf: The percentage of variables that were in conformance, which is calculated as:

(sum (number of values in target * number of test values)) / total number tested

For example, if Variable A had 3 out of 10 values in target, Variable B had 6 out of 10 values in target, and Variable C had 9 out of 10 values in target, then the % conformance would be 60% (18/30)
Cpk: The process capability index. For detailed information on Cpk, see Variable Property Definitions: Cpk.

Ppk: The process performance index. For detailed information on Ppk, see Variable Property Definitions: Ppk.
Cp: The process capability ratio. For detailed information on Cp, see Variable Property Definitions: Cp.
Pp: The process performance indicator. For detailed information on Pp, see Variable Property Definitions: Pp.
%Dev: This is calculated as follows:

sum (CoefficientVariationTarget * number tested) / sum (number tested)
where
CoefficientVariationTarget = (standard deviation of the Target Deviation / minimum target value) * 100.00
where
Target Deviation = variable result value – variable target value
%Sigma: This is calculated as follows:

(sum (Standard Deviation / Average * 100.00 * number tested)) / sum (number tested)
where
Standard Deviation = standard deviation of the results for each variable
and
Average = average of the results for each variable
%Test: The percentage of variables that had result values, calculated as follows:

sum (number of non-null values for each variable) / sum (total number of samples)

Create the web part. How?
On the Report Parameters tab, click the Edit Parameter button.
On the Variable tab, select the unit, then the child unit (if applicable), and next select the variable.
Click Next.
On the Start Time and End Time tab, select the period of time you want to retrieve information for.
Click Next.
On the Product Filter tab, select the products you want to retrieve information for.

Click Next.
On the Cpk Mode tab, select either Cpk Weighted Average or Cpk by Product. If you select Cpk Weighted Average, calculations are made across all products. If you select Cpk by Product, calculations are made per product and the user will be able to scroll through all available products with the arrows in the top right of the web part display.
Click Next.
On the Options tab, select the Filter Non-Productive Time check box if you want to exclude non-productive time from the calculations.
Click Next.
On the Finish tab, click Finish.