-
-
The item called Data Access represents a simple way to access Historian data. The workflow is usually as follows:
-
Find the signals that you're looking for
-
Configure the time range and data transformations
-
Display charts or export data via files
-
-
-
Find the desired signals. In the page Data Access click the left menu item called Find signal, which opens a new panel.
-
You will probably need to narrow your search result using the integrated filter by specifying signal Unit/System/Equipment/Signal or part of the Description.
-
-
-
Selected signals are presented at the top of the left menu. You may add as many signals as you want.
-
-
-
The range can be provided either relatively – by specifying a FROM date
-
Select one of predefined ranges (day/week/month/year/etc.) or absolutely – by picking custom range and specifying exact FROM&TO dates.
-
-
-
Now you need to decide whether you want to see the RAW data ( by picking RAW in the Interval dropdown) or some aggregated data (selection Per second/Per minute/Per Hour/Per Day).
-
If you have selected any form of aggregation, you can also configure the aggregation step (Interval Per Minute with Step 30 means that you will get value for every 30 minutes)
-
-
-
Separate Charts: A separate line-chart is shown for each individual signal.
-
-
-
Joint Chart: Shows one line-chart for all selected signals and therefore allows a direct comparison of the values.
-
-
-
Point Chart:This typically requires selecting two signals (one for horizontal and one for vertical axis with point color based on the time range) or three signals (where the point color is based on the values of the third signal).
-
-
-
1- Using the buttons in the top right corner , each chart can be: • downloaded as PNG image • customized • switched to full screen view.
-
2- When using Separate or Joint charts (not Point-Charts) you can also jump to different time ranges simply by clicking the arrows in the left top corner.
-
The chart appearance can be customized using the configuration dialog. Based on the chart type, you may change: (1) series color; (2) time axis parameters; (3) numerical axis parameters.
-
-
-
Panel Signal Groups (1) allow them to store their selection for a later use.
-
This can be done by clicking the Save as button (2) and providing a unique name for the group.
-
You can get back to any group by clicking the Open button (3). Or you may only pick signals from this group and add them to your selection by the Use signals button.
-
-
-
The export panel which opens under the Data Export menu item (1) summarizes the export parameters - list of signals, aggregations, file format (2) - and allows a precise specification of the time range (up to the seconds).
-
The export is started using the Export button (3). Large exports might take a while to process.
-
-
-
You can open this tool in the Data Access tab by clicking the Report Command Tool either in the main left menu (1) or in the detail of each selected signal (2).
-
Once you’re in the dialog, you can choose the expected result (1). You might want:
-
Date & Time (e.g. to put current date in some particular cell)
-
One Value – one number of a specified signal at some moment of time (e.g. number of operation hours at noon)
-
List of values – multiple numbers of one signal (e.g. average temperatures per hour during the day
-
Totalized value (e.g. burned gas during last 24 hours as calculated from gas flow)
-
Once your formula is set, you see its exact syntax in the Excel command field and you may let Historian to evaluate the formula using the Test command button (2). You may use the Copy to clipboard button (3) to copy-paste your formula into your Excel template.
-
Almost done!
Finish Line