average and Mean values of Trend
i need to get mean values and average values of all trends of 1 hour.
I tried with BDM and data direct.
with BDM we can fetch the property configured like average or time average but didn't get current values of property defined.
is there anyway to get curent value of property
pls find attched screenshot for refernce.
Voted best answer
I recommend using Excel and DataDirect which can read online OPC server values and from configured property logs running in a historian, eg Basic History.
1. ABBGetOPCDA() return current value from the OPC server.
2. ABBGetOPCHDA() can read from any property log (possibly with additional aggregate).
A lot can be prepared by implementing a suitable log hierarchy and selection of log aggregates.
Eg a secondary log with Min Time = 1 hour and TimeAverage would reduce the work required in DataDirect down to reading just one single value with ABBGetOPCHDA(). The log will also have the averaged values nicely aligned on even hours.
The primary log will contain the most recent values in case it is necessary to have them (hence, you should be able to survive on HDA functions alone which offload the OPC server and anyway should be quicker than using "online" DA functions).