Sift Rule Variables

~siftrule~

Returns various summary statistics on data in a DataSet that is associated with a particular Sift Rule.

Sift Rule Stats

The variable, ~siftrule~, can be used to report various summary statistics on data in a DataSet that is associated with a particular Sift Rule.

~siftrule,boxhi~

Box high value

~siftrule,boxlo~

Box low value

~siftrule,conformcount~

Number of conforming values

~siftrule,cp~

Cp value

~siftrule,cpk~

Cpk value

~siftrule,cr~

Cr value

~siftrule,hi~

Highest value

~siftrule,invalidcount~

Number of invalid values

~siftrule,iqr~

Inter quartile range

~siftrule,lif~

Lower inner fence value

~siftrule,lo~

Lowest value

~siftrule,lof~

Lower outer fence value

~siftrule,lowerlimit~

Lower limit value

~siftrule,mean~

Mean value

~siftrule,median~

Median value

~siftrule,nonconformcount~

Number of nonconforming values

~siftrule,nospeccount~

Number of valid values that do not have a specification limit

~siftrule,nospeccount2~

Number of valid values that do not have a specification limit 2.

~siftrule,outofspeccount~

Number of valid values that are out of specification.

~siftrule,outofspeccount2~

Number of valid values that are out of specification 2.

~siftrule,percentconform~

Percentage of conforming values

~siftrule,percentnonconform~

Percentage of nonconforming values

~siftrule,percentinvalid~

Percentage of invalid values

~siftrule,percentvalid~

Percentage of valid values

~siftrule,pp~

Pp value

~siftrule,ppk~

Ppk value

~siftrule,pr~

Pr value

~siftrule,q1~

Quartile one value

~siftrule,q3~

Quartile three

~siftrule,range~

Range value

~siftrule,rowcount~

Number of rows

~siftrule,stddev~

Stddev value

~siftrule,sum~

Sum value

~siftrule,totalcount~

Number of values

~siftrule,uif~

Upper inner fence value

~siftrule,uof~

Upper outer fence value

~siftrule,upperlimit~

Upper limit value

Calculating Stats on One Sift Rule

When the ~siftrule~ variable is used with two additional parameters, the calculation is done only for the Sift Rule that is specified by the first parameter. The second parameter is the statistic that will be calculated on the data included in the Sift Rule specified by the first parameter.

The first parameter can be specified using one of the following options:

• Number of Sift Rule - the integer that indicates the position of Sift Rule in the list, as it appears in the Multiple Sift Rules dialog.

• Label of Sift Rule - label of Sift Rule.

When the variable is used with the Evaluation/SiftRule Variable DataStack type, the first parameter is not used. See also, DataStacks - Evaluation - Sift Rule Variable.

Current Sift Rule Variables

The current Sift Rules can be returned using the following variables:

~siftruletype~

Returns "multiple" or "single".

~reportsiftrule~

Returns the sift rule used for the report.

~sheetsiftrule~

Returns the sift rule used from the multi-sift.