Skip to main content
InSource KnowledgeCenter

041457 - Aggregate MAX query does not work from an excel report

Problem

User is using the Excel reporting feature of Historian Client. He is using the wwAggreate function to find the max value of a tag for an hour time frame. When he does this though it returns the message "No records". When he looks in trend however he can clearly see two values occurring over the hour.

Product Version: 10.0

OS: Win 2008 64 bit

Solution

It looks like this was actually caused by holes in the data. As time progressed the report began working. When htey looked back, the times it did not work they believe was due to the historian being restarted.

Close Date: 2011-11-03 13:34:10