AnsweredAssumed Answered

Count Number of Values with Timstamp Close to the Hour

Question asked by Miles Buckley on Oct 22, 2015
Latest reply on Oct 26, 2015 by Miles Buckley

I have noticed that some of the real-time data from our SCADA system is unusually timestamped within one minute of the hour and not spaced out as we would expect.

Is there a way to count the number of values (per day for example) that have timestamps as described and compare with the total for the same time period.

 

I've tried downloading the data with datalink but there is just far too much of it and Excel grinds to a halt.

 

Miles

Outcomes