Content

Overview Description Configuration Properties

 

Overview	Top

The "Data Trend" Control inserts a Data Trend Chart into an ELN/LES Worksheet. This Control provides OOB Global Control Templates that can chart data either for a collection of nominated Samples, or as a trend of Samples linked by different SDCs (such as Instruments for Calibration Samples or Location/Sample Point for Monitor Samples).

 

Description	Top

The Data Trend Control is capable of accepting SDIs and their data into the Worksheet. The example below shows a Data Trend Control from the "Sample Trend" Global Template, along with the plotted data. The data have been defined by a Data Entry Control in the Worksheet (shown at the left of the Data Trend Control).

 

Configuration Properties	Top

These properties are available for configuring overall behavior.

Property	Description
Data Source	Determines the source of the SDIs associated with the Control. Option Description Worksheet SDIs are retrieved from the WorksheetSDI table, which persists SDIs associated with the Worksheet. Control SDIs are retrieved from the WorksheetItemSDI table, which persists SDIs associated with the Control.
Data Source SDC	SDC for the SDIs that are in the Control or Worksheet.
Trend Over SDC	SDC that has SDI Data Items. This is typically "Sample". This property is used only if the "Data Source SDC" is "SDIWorkItem".
Range Mode	Defines the range of the chart. Option Description SDIList Retrieves results from SDIs linked to this Control. In this case, you would usually link multiple SDIs to the Control. Count Retrieves "N" results back from the base SDI. In this case, you must link exactly one SDI to the Control, and that is used as the base. Selecting this option shows the "Order By Column", "Back Count", and "Matching Columns" properties. Date Retrieves results "N" days back and "K" days forward from the base SDI. In this case, you must link exactly one SDI to the Control, and that is used as the base. Selecting this option shows the "Order By Column", "Days Back", "Days Forward", and "Matching Columns" properties.
Order By Column	This is shown if "Range Mode" is "Date" or "Count". When retrieving results back from the base Sample, the results must be ordered. This column is used to order retrieved SDIs. If "Date", this must be a date-type column (typically createdt or collectiondt).
Days Back	This is shown if "Range Mode" is "Date". Results will be retrieved "N" days back from the base SDI.
Days Forward	This is shown if "Range Mode" is "Date". Results will be retrieved "K" days forward from the base SDI.
Back Count	This is shown if "Range Mode" is "Count". Retrieves "N" results back from the base SDI.
Matching Columns	When retrieving results back from the base, this defines the Samples to retrieve. This collection of columns is used to get Samples with matching values in all listed columns.
Workitem Workitem Instance Param List Param List Version Variant Param Param Type	Defines the Workitem/Parameter List/Parameter for the data that will be trended. If not defined, all results will be trended for the retrieved Sample.
Ignorer Cancelled	Determines if Cancelled results will be displayed.
Released Only	"Yes" plots only data that have been Released in Data Entry.
Result Entered	Determines if empty results are retrieved.
Include Outliers	Determines if results marked as "Outliers" are retrieved.
Ignore Retested	Determines if results that have been Retested are retrieved (as indicated by SDIData.s_RetestedFlag).
Ignore Remeasured	Determines if results that have been Remeasured are retrieved (as indicated by SDIData.s_RemeasuredFlag).
title	title shown on the chart.
Width	Width of the chart in pixels.
Height	Height of the chart in pixels.
Operations	Defines operations available on the Control Toolbar. See Common Control Operations for details.
Includes	Allows complex/extended JavaScript to be added to an Operation of Type "Custom".