Issue
Is there a way to output the average of logged values contained within the I/A Series G3 history records?
Environment
I/A Series G3
Cause
I/A Series G3 history tables contain records of values logged by the associated trend objects. A BQL query must be used to read records from the table and perform a calculation to average the values.
Resolution
A program object that contains a BQL query can be used to read the records from a history table and calculate minimum, maximum, average, etc. The AX community module contains a BQL object (Trend Dynamic Analyzer) that can be assigned to a history ord and configured to a particular timeframe. A new trend with a specific number of records (rolling) can be queried by this object which in turn calculates the Count, Min, Max, Average, and Sum.
The axCommunity module contains a library of useful objects for the Tridium Niagara AX platform created by AX programmers. Download the axCommunity module from the following website - http://sourceforge.net/projects/niagaraaxcommun/.
Note: Schneider Electric does not maintain and is not responsible for the content within the axCommunity module. The user should test and utilize at their discretion and risk.
- Copy the axCommunity.jar file into the Workbench platform (modules folder). Install into the target platform as needed.
- Open the axCommunity palette and add a TrendDynamicAnalyzer object into the station.
- View the TrendDynamicAnalyzer property sheet and then assign the History using the History Ord Chooser.
- Connect an Interval Trigger if a time based refresh of the values is required. You may want to limit the values at the output if the values trended by the history can get out of range (e.g. initialization, etc.).