Measurement Data Variables

~act~

Value of actual for the characteristic specified in the query.

~act,[char]~

Returns the actual value for the specified characteristic. For example ~act,pos~ returns the actual value for the Position characteristics.

~act,cause~

Returns the label of the assigned cause, if a cause has been assigned.

~act,cause,comment~

Returns the comment of the assigned cause, if a cause has been assigned. See also ~cause,comment~.

~act,cause,desc~

Returns the label and the description of the assigned cause, if a cause has been

assigned.

~act,status~

Can return one of the following strings:

~acttype~

Returns the type of the actual data.

~acttype,[char]~

Type of results data for the specified characteristic (Actual or Deviation).

~actvalue~

Returns the value of the actual data.

~actvalue,[char]~

Raw value of results data for the specified characteristic.

~cellsamp~

Returns the label for the sample resolved for the cell. For DataSets with multiple Routines, this resolves as the row number.

~cellsamp,label~

Returns the label for the sample resolved for the cell. For DataSets with multiple Routines, this variable will resolve the text of a chart axis as the Sample Label instead of the DataSet column number. This is best used with either a single feature or with Routines that have corresponding samples.

Chart Properties - Axis Text
Chart Properties - Axis Text + Variable

Single Routine
Multiple Routines
Multiple Routines with Variable



~cellsamp,filter,[a-z]~

Returns the specified filter for the sample resolved for the cell. For DataSets with multiple Routines will resolve the text of a chart axis as the Sample Label instead of the DataSet column number. This is best used with either a single feature or with Routines that have corresponding samples.

~dev~

Returns the deviation value based on the query setting.

~dev,[char]~

Returns the deviation value of the specified characteristic, based on the query setting.

~devtype~

Returns the deviation type, Vec or Car, based on the query setting.

~sampdatecount~

Returns the amount of unique dates in a row.

~sampdateordered~

If the samples are ordered by date, this variable returns the value 'Yes'. If the samples are not ordered by date, this variable returns the value 'No'.

~samp~

Returns the label of the current sample. This is the same as ~samp,label~. When a Sample [Parameter] is appended to any sample variables, the DataSet results will be overridden and the sample signified by the sample paramter will be returned.

~samp,archdate~

Returns the archive date of the sample.

~samp,archdays~

Returns the number of days after the creation date until the samples are archived.

~samp,archtype~

Returns the archive type of the sample: Date, Days, or Never.

~samp,date~

Returns the creation dates of the samples in a DataSet.

~samp,date,%__~

Returns the creation dates of the Sample in a format specified by the specified Date parameter(s).

For example, if the date was March 14, 2002, ~samp,date,% d-%b-%Y~ would resolve to "14-MAR-2002". If the time were 08:12:59, ~samp,date,% M past % H~ would resolve to "12 past 08". See here for a complete list of parameters.

~samp,desc~

Returns the description of the sample.

~samp,effdate~

Returns the effective date of the current sample.

~samp,filter,[filterlabel]~

Returns the value assigned to the sample filter associated with the sample. This variable replaced the obsolete variable, ~sample,filter,info~.

~samp,impdate~

Returns the import date of the sample.

~samp,index~

Returns the position of the sample as it exists in the Query.

~sample,label~

Returns the sample label. This is the same as ~samp~ and is the default sample parameter.

~samp,order~

Returns the number of the Sample’s position based on the order of Samples in the Query.

~samp,seq~

Returns the sequence number of the sample.

~samp,status~

Returns the status of the sample:

o       Active - Loaded from database, displayed and used in statistical calculations.

o       Masked - Loaded from database and displayed, but not used in statistical calculations.

o       Missing - No data exists.

o       Hidden - Data exists, but is not loaded from database.

o       Archived - Not loaded from database and will be archived.

~samp,subgroup~

Returns the subgroup label.

~samp,subgroupseq~

Returns the sequence order within the subgroup.

~samp,type~

Returns the sample type: Var, HVD, or Mix.

~sample~

Returns the label of the current sample. This is the same as ~samp~.

~sample,serial~

Returns the serial number of the sample.

~samples~

Number of samples in a DataSet.