The Parameter Chart analysis tool is available to help with parameter data quality assurance before import in to your Essential database. View relationships between different parameter values stored in the PDM (Process Data Manager) Staging table. For example, a chart can be used to review historical parameters for trending as well as projecting futures values. Plot Time Series data for one or more parameters or plot Parameter vs. Parameter data. Line, column, area, bubble, and point (scatter) chart type formats are available. The Parameter Chart tool can be accessed from the Parameter Import Review form and the Parameter Group Import Review form for the selected parameter.
Note:
A simple line chart of the values that are included in an import
batch can be viewed on the Parameter
Group Import Review form. Refer to Parameter
Import Results Review and Approval for additional information.
For instruction on parameter charting, click the following links or use the scroll bar to scan the page.
|
|
|
When a chart is displayed, the following navigation features are available to help you review plotted data:
Move the mouse over a data point in the chart to view the actual value.
To view different charting formats, radio buttons have been provided; e.g., line, bar, area, bubble, or point. Click a respective chart format radio button to automatically redraw the chart. Click Show All to redraw the chart with all the data.
Select a subset of the chart by pressing the SHIFT Key and dragging your mouse over the plotted data. The chart is redrawn with the coordinates captured during the mouse selection. Scroll down with the mouse wheel to redraw the chart with all the data.
Memory use for the Area chart type format is high. For optimal performance, it is recommended that a smaller date range be specified. To help with rendering issues, always maximize the chart window before selecting the Area chart.
Plot time series data with the Quick Chart or Advanced option. Quick Chart provides a line chart of the selected parameter's values for a user-defined time period. When generating a Quick Chart from the Parameter Import Review form, the start and end dates default to the last calendar month. When generating from the Parameter Group Import Review form, the date range defaults to the start and end date of the import batch. Dates and times can be changed before a chart is generated. Both staging values (pending import) and parameter results (imported to Essential) are plotted.
The Advanced charting option provides the following additional features:
Generic time periods, such as Today, Yesterday, and Last Quarter, are available for selection. The Start Date and End Date fields will be automatically completed based on the time period chosen. For example, select Last Week and the previous week's Sunday date plus 12:00:00 AM (inclusive) are entered as the start date/time. The end date/time is the following Sunday's date and 12:00:00 AM (exclusive).
Offset hours can be entered to adjust the start/end date and time. This option applies to parameters selected on the Parameter Group Import Review form.
Multiple parameters can be selected. The name of the entity or process/production/emission unit associated with the parameter is included for identification purposes.
Staging values (pending import) and/or parameter results (imported to Essential) can be plotted and a chart color can be selected for each.
Filter the data to be plotted by Record State and/or Import Status.
The charted data can be exported to Excel.
A secondary parameter filter is available to compare the results of one parameter with another. For example, you could chart the emission variances for a generator when using "Coal Type A" versus "Coal Type B". Use a load-related parameter and select the "Coal Type A" parameter. Add the "Coal Type B" parameter as a filter to compare results in side-by-side charts. An overlay option is available for a single chart comparison. Filter parameters must be set up to use the Text value. The unique values in the date range specified for the chart must be less than 10.
Parameters that are to be included in a particular chart can be grouped. For example, if there are five parameters included in the chart configuration, two can be included in one overlay chart and remaining three in another overlay chart.
A chart title can be specified for each parameter. It appears centered at the top of the chart. A maximum of 255 characters can be entered; the default is the parameter name. For grouped parameters, the chart title for each parameter in the group is displayed in a separate row.
A Z-index property can be specified for each parameter. The Z-index property specifies the stack order of a chart (i.e., which chart should be placed in front of, or behind, the others). A chart with greater stack order is always in front of another chart with a lower stack order.
For both the Quick Chart and Advanced Chart, a maximum of 5000 points can be plotted.
To generate a time series Quick Chart
Use one of the following methods to access the Parameter Chart Options window:
Open the Parameter Import Review form and click View Chart.
Open the Parameter Group Import Review form, select a parameter record, and click View Chart in the Parameter Group Batch Details section.
Review the start and end date and time. Make changes when applicable.
Click Quick
Chart to generate the chart. The Quick
Chart button is only available when the Plot
Time Series option is selected.
Move the mouse over a data point in the chart to view the actual value.
Refer to Chart Navigation for information
about additional chart features.
To generate a time series Advanced Chart
Use one of the following methods to access the Parameter Chart Options window:
Open the Parameter Import Review form and click View Chart.
Open the Parameter Group Import Review form, select a parameter record, and click View Chart in the Parameter Group Batch Details section.
Ensure the Plot Time Series option is selected and click Advanced.
Review the start/end date and time. Use the following guidelines to edit the existing values:
Type a different date or click the Calendar button to select a date.
Type a new time, as well as AM/PM designation when applicable, or click the Clock button to select a different time. Alternately, you can place your cursor before a number and click the up/down arrows to change that number.
Select a period of time by clicking one of the available options. The Start Date and End Date fields will be automatically completed based on the selection. For example, click Last Week and the previous week's Sunday date plus 12:00:00 AM (inclusive) are entered as the start date/time. The end date/time is the following Sunday's date and 12:00:00 AM (exclusive).
The Hour Offset option is available when the parameter has been selected on the Parameter Group Import Review form. Click Hour Offset, select an offset option (plus, minus, or both), enter the number of hours, and click the Apply relative to date link. The start/end date and time entries are adjusted accordingly.
Click Add
Parameter to include the data for one or more additional parameters
in the chart. You may want to clear the From
same Unit and Parameter Type check box first. If no parameters
are to be added, skip to step 6.
When comparing data with multiple filters, the same parameter needs
to be added for each different filter.
Select one or more parameters by
clicking the check box adjacent to the parameter and clicking OK.
The selected parameters are displayed in the Parameter
Chart Settings section. Remove a parameter by clicking the
Delete icon adjacent to the
parameter name.
Select the data to be charted, staging values (pending import) and/or parameter results (imported to Essential), and select a chart color from the list.
Filter the data to be charted by selecting one or more Import Status and/or Record State.
Click Add Filter to compare data from another parameter. You may want to clear the From same Unit and Parameter Type check box first. If no filters are to be added, skip to step 12.
Select a parameter by clicking the
check box adjacent to the parameter and clicking OK.
The selected parameter is displayed in the Filter
column of the Parameter Chart Settings
section. Remove the filter by clicking Clear
Filter.
Select the Overlay chart based on filter value option when applicable.
Add another filter by repeating steps 4 through 10. The same parameter needs to be added for each different filter.
Change the Chart Title when applicable. A maximum of 255 characters are available.
Group parameters for a chart by assigned each parameter to be included in a group the same number in the Chart Group field.
Select a Chart Type format from the list and specify the Z-Index (a property that specifies the chart stack order, i.e., which chart should be placed in front of, or behind the others) when applicable.
Click Chart
in the Date Range section
to generate the chart.
Move the mouse over a data point in the chart to view the actual value.
Refer to Chart Navigation for information
about additional chart features.
Click the Parameter Chart Settings section header to specify different criteria and generate another chart. Click the Export to Excel button in the Date Range section to export chart data to Excel.
Generate a Parameter vs. Parameter chart to compare data for two parameters. The record timestamp of the first parameter must match a record timestamp of the second parameter in order for a value to be included in the chart. Staging values (pending import) and/or parameter results (imported to Essential) can be plotted up to a maximum of 5000 points. Import Status and Record State filters are available.
When generating a Parameter vs. Parameter chart from the Parameter Import Review form, the start and end dates default to the last calendar month. When generating from the Parameter Group Import Review form, the date range defaults to the start and end date of the import batch. Dates and times can be manually changed before a chart is generated. In addition, generic time period options, such as Today, Yesterday, and Last Quarter, can be selected. The Start Date and End Date fields will be automatically completed based on the selection. For example, select Last Week and the previous week's Sunday date plus 12:00:00 AM (inclusive) are entered as the start date/time. The end date/time is the following Sunday's date and 12:00:00 AM (exclusive). Offset hours can be entered to adjust the start/end date and time. This option applies to parameters selected on the Parameter Group Import Review form. If there are two values/results with the same timestamp, the record with the most recent SYS_UPDT_TIME entry will be plotted.
The default chart format is a point (scatter) chart. When the chart is displayed, move the mouse over a data point in the chart to view the actual value. Refer to Chart Navigation for information about additional chart features.
Charted data can be exported to Excel.
To generate a Parameter vs. Parameter ChartUse one of the following methods to access the Parameter Chart Options window:
Open the Parameter Import Review form and click View Chart.
Open the Parameter Group Import Review form, select a parameter record, and click View Chart in the Parameter Group Batch Details section.
Select the Plot Parameter vs. Parameter option and click Advanced.
Review the start/end date and time. Use the following guidelines to edit the existing values:
Type a different date or click the Calendar button to select a date.
Type a new time, as well as AM/PM designation when applicable, or click the Clock button to select a different time. Alternately, you can place your cursor before a number and click the up/down arrows to change that number.
Select a period of time by clicking one of the available options. The Start Date and End Date fields will be automatically completed based on the selection. For example, click Last Week and the previous week's Sunday date plus 12:00:00 AM (inclusive) are entered as the start date/time. The end date/time is the following Sunday's date and 12:00:00 AM (exclusive).
The Hour Offset option is available when the parameter has been selected on the Parameter Group Import Review form. Click Hour Offset, select an offset option (plus, minus, or both), enter the number of hours, and click the Apply relative to date link. The start/end date and time entries are adjusted accordingly.
Click Add Parameter to select the second parameter. You may want to clear the From same Unit and Parameter Type check box first.
Select a parameter by clicking the
check box adjacent to the parameter and clicking OK.
The selected parameter is displayed in the Parameter
Chart Settings section. Remove a parameter by clicking the
Delete icon adjacent to the
parameter name.
Select the data to be charted, staging values (pending import) and/or parameter results (imported to Essential).
Filter the data to be charted by selecting one or more Import Status and/or Record State.
Click Chart
in the Date Range section
to generate the chart.
Move the mouse over a data point in the chart to view the actual value.
Click the Parameter
Chart Settings section header to specify different criteria
and generate another chart.
In order to add a different parameter, one of the existing parameters
must be deleted first.
Click the Export to Excel button in the Date Range section to export chart data to Excel when applicable.
