DataSet Variables

DataSet Contents

~cell~

Returns the value of a cell in a DataSet. The ~cell~ variable requires a row to be specified in the DataSet, and must have an active sample.~

~cellsamp~

Returns the sample which was resolved for the cell.

~chr~

Will return the characteristic used in a DataSet row.

~chr,1~

Returns the first a letter of the characteristic type.

~datastate~

Returns Collecting Data or Not Collecting Data. The ~datastate~ variable returns" Collecting Data" if a DataSet is in Collecting Data mode, or "Not Collecting Data" if the DataSet is in any mode other than collecting data.

Counts

~count~

Returns the number of valid values within a DataSet row.

~invalidcount~

Number of invalid values in DataSet row. Invalid data is not nonconforming data and so will not be included in the ~validcount~ results.

~nospeccount~

Number of valid values in a DataSet row that do not have a spec limit.

~nospeccount2~

Number of valid values in a DataSet row that do not have a spec limit 2.

~outofspeccount~

Returns the number of values in a DataSet row that are out of spec, or out of tolerance, regardless of the Event Trigger setting.

~outofspeccount2~

Returns the number of values in a DataSet row that are out of spec 2, or out of tolerance 2, regardless of the Event Trigger setting.

~percentvalid~

Percentage of valid values in DataSet row.

~percentinvalid~

Percentage of invalid values in DataSet row.

~row~

Returns number of the DataSet row.

~row,actual~

Returns the active row number in a DataSet.

~row,actualcount~

Returns a count of the number of active rows in a DataSet.

~row,virtual~

Returns the active row number from the map column in a DataSet when Multiple Sift Rules are being used.

~row,virtualcount~

Returns the total number of active rows from the map column in a DataSet when Multiple Sift Rules are being used.

~rowlabel~

Returns the label of the DataSet row.

~rows~

Returns the number of rows in the DataSet.

~samples~

Number of samples in a DataSet.

~validcount~

Returns the number of valid values within a DataSet row.

DataSet Properties

~compareprecision~

Returns the Compare Precision number set on the Document Properties Defaults Tab.

~dataset~

Returns the label of the DataSet.

DataSet Statistics

~boxhi~

Highest value in DataSet row that is within the uif (Upper Inner Fence).

~boxlo~

Lowest value in DataSet row that is within the lif (Lower Inner Fence).

~dataset,boxhi~

Returns the box highest value for the entire DataSet.

~dataset,boxlo~

Returns the box lowest value for the entire DataSet.

~dataset,conformcount~

Returns the number of conforming values in a DataSet.

~dataset,cp~

Returns the Cp value of the data in the DataSet. There are two limitations to calculating Process Capability on a DataSet:

·        All cells in the DataSet must have a Tolerance, and the Tolerance must be the same for all cells in the DataSet.

·        Subgroups will not be applied when using the Cpk parameter.

~dataset,cpk~

Returns the Cpk value of the data in the DataSet. There are two limitations to calculating Process Capability on a DataSet:

·        All cells in the DataSet must have a Tolerance, and the Tolerance must be the same for all cells in the DataSet.

·        Subgroups will not be applied when using the Cpk parameter.

~dataset,cr~

Returns the Cr value of the data in the DataSet. There are two limitations to calculating Process Capability on a DataSet:

·        All cells in the DataSet must have a Tolerance, and the Tolerance must be the same for all cells in the DataSet.

·        Subgroups will not be applied when using the Cpk parameter.

~dataset,hi~

Returns the high value for the entire DataSet.

~dataset,invalidcount~

Returns the number of invalid values in an entire DataSet.

~dataset,iqr~

Returns the inter quartile range for the entire DataSet.

~dataset,lif~

Returns the lower inner fence value for the entire DataSet.

~dataset,lo~

Returns the lo value of the entire DataSet.

~dataset,lof~

Returns the lower outer fence value for an entire DataSet.

~dataset,lowerlimit~

Returns the lower limit for the entire DataSet.

~dataset,mean~

Returns the mean value for the entire DataSet.

~dataset,median~

Returns the median value for the entire DataSet.

~dataset,nonconformcount~

Returns number of nonconforming values in a DataSet

~dataset,nospeccount~

Returns the number of valid values in an entire DataSet that do not have a spec limit.

~dataset,nospeccount2~

Returns the number of valid values in an entire DataSet that do not have a spec limit 2.

~dataset,outofspeccount~

Returns the number of valid values in a DataSet that are out of spec.

~dataset,outofspeccount2~

Returns the number of valid values in a DataSet that are out of spec2.

~dataset,percentconform~

Returns percent of conforming values in a DataSet.

~dataset,percentnonconform~

Returns percent of nonconforming values in a DataSet.

~dataset,percentinvalid~

Returns the percent of invalid values in an entire DataSet.

~dataset,percentvalid~

Returns the percent of valid values in an entire DataSet.

~dataset,pp~

Returns the Pp value of the DataSet.

~dataset,ppk~

Returns the Ppk value of the DataSet.

~dataset,pr~

Returns the Pr value of the DataSet.

~dataset,q1~

Returns the quartile one value for an entire DataSet.

~dataset,q3~

Returns the quartile one value for an entire DataSet.

~dataset,range~

Returns the range value for the entire DataSet.

~dataset,rovcenter~

Returns the ROV Center for the entire DataSet.

~dataset,rovspread~

Returns the ROV Spread for the entire DataSet.

~dataset,rovtarget~

Returns the ROV Target for the entire DataSet.

~dataset,rowcount~

Returns the number of rows in the DataSet. See also, ~rows~.

~dataset,stddev~

Returns the Standard Deviation of the DataSet.

~dataset,sum~

Returns the value of the sum of an entire DataSet.

~dataset,totalcount~

Returns the number of values in an entire DataSet.

~dataset,uif~

Returns the upper inner fence value for the entire DataSet.

~dataset,uof~

Returns the upper outer fence value for an entire DataSet.

~dataset,upperlimit~

Returns the upper limit for the entire DataSet.

~hi~

Highest of valid values within a DataSet row.

~lo~

Lowest of valid values within a DataSet row.

~mean~

Average of valid values within a DataSet row  

~mean,r~

Mean range of subgroup ranges within a DataSet row  

~mean,s~

Mean standard deviation of subgroup standard deviations within a DataSet row  

~mean,mr~

Mean moving range of subgroup moving ranges within a DataSet row  

~mean,ma~

Mean moving average of subgroup moving averages within a DataSet row  

~mean,ga~

Grand average of subgroup averages within a DataSet row. This is the same as ~mean~, unless some subgroups were found to be invalid because they had invalid or missing sample values. Subgroups with invalid values are removed from statistical calculations since their subgroup size is affected.

~median~

Middle value of DataSet row.

DataSet Conformance

Conformance refers to whether or not an event was triggered in the current process. For example, if tolerance was selected for the event type, and the data was triggered as being out of tolerance, then the data was nonconform.

DataStack Variables

~grade~

Requires a DataStack as the DataSource. Grade looks at every cell of the entire DataStack and checks to see if the values are within Spec Limits. The ~grade~ variables are very similar to the ~tally~ variables.

~grade,count~

Returns the number of valid values in tolerance. This variable must use a DataStack as its DataSource, and the DataStack must have limits.

~grade,total~

Returns the total number of valid values. This variable must use a DataStack as its DataSource, and the DataStack must have limits.

~grade,percent~

Returns the percent of valid values in tolerance (count divided by total). Percent is rounded to nearest integer (no % sign).